Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi everyone!
I've got the following column:
FilteredColumn= COUNTROWS ( FILTER ( 'Table1'; 'Table1'[Val1] = "0" && 'Table1'[Val2] = "Closed" && 'Table1'[Val3] < 16 ) )
It's working fine, but now I've got an other filter that I don't know how to aply it.
I've go some new values, lets name them Val4, Val5 and Val6
What I need is to make the following condition:
If Val4 = 5 && Val5 = 2017, then I need to bring those values where Val6 is between 2 dates.
So, I will have 12 conditions in that if statement:
If Val4 = 1 && Val5 = 2017, then show me those values where Val6 is between Dec-16 and Jan 2017
If Val4 = 2 && Val5 = 2017, then show me those values where Val6 is between Jan-17 and Feb 2017
If Val4 = 3 && Val5 = 2017, then show me those values where Val6 is between Feb-17 and Mar 2017
and so on...
Is it possible to integrate that if statement, with the 12 conditions (one per month), in the "FilteredColumn" so I can get those values wich are:
Val1 = "0"
Val2 = "Closed"
Val3 < 16
If Val4 = 1 && Val5 = 2017, then show me those values where Val6 is between Dec-16 and Jan 2017
If Val4 = 2 && Val5 = 2017, then show me those values where Val6 is between Jan-17 and Feb 2017
If Val4 = 3 && Val5 = 2017, then show me those values where Val6 is between Feb-17 and Mar 2017
.. etc..
Hope you can undestand me, such as English is not my first language.
Kind regards!
@chrisgehm,
It is difficult for us to provide you DAX based on the above description. Could you please share sample data of Table1 and post expected result in a table?
Regards,
Lydia
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |