Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.