Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear community,
I'm relative new to Power Bi, but experienced with Excel.
I'm trying to get my head around the filter function in combination with calculate. I have the following expression:
Check this article on filter arguments. Hope it will help
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
When you write a boolean expression
1
2
3
4
|
CALCULATE ( <expression>, table [column] = < value > ) |
In reality the filter expression you wrote is transformed into
1
2
3
4
5
6
7
|
CALCULATE ( <expression>, FILTER ( ALL ( table [column] ) , table [column] = < value > ) ) |
It is a very interesting link and I've added it to my favorites, but it seems it is not an answer to my question.
I do see I've forgotten on the critical line to type the filter expression. I've updated my original post with the correct line, sorry for the inconvenience. Below the line I've updated
'case history'[CreatedDate] < [Old Pending] filter ( 'case history' , 'case history'[CreatedDate] < 'case history'[Old Pending] )
I want to assign [Old Pending] as the value in the record that has to be matched in column [CreatedDate]. Thus as a solution, I've now thrown [CreatedDate] in a seperate table with unique values. However, this is not ideal.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |