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.
Hi Everyone,
My first post here, very new to Power BI. Let's imaging a table [Work Status] that looks like below.
Now I want to create a new column to return the first date of Finished status for each unique Item ID which is 7/11/2013.
The DAX which I wrote doesn't work:
Status Finished Date = CALCULATE(MIN('Work Status'[Date From], FILTER('Work Status', 'Work Status'[Status] = "Finished"))
Proprobaly I should not use CALCULATE?
Need help thanks!
Solved! Go to Solution.
Sorry I think I misplaced the brackets
Try this one
Status Finished Date = CALCULATE ( MIN ( 'Work Status'[Date From] ), FILTER ( ALLEXCEPT ( 'Work Status', 'Work Status'[item id] ), 'Work Status'[Status] = "Finished" ) )
Try with this revision
Status Finished Date = CALCULATE ( MIN ( 'Work Status'[Date From], FILTER ( ALLEXCEPT ( 'Work Status', 'Work Status'[item id] ), 'Work Status'[Status] = "Finished" ) ) )
Hi Zubair,
I tried your code in both measure and calculated column and it returns me the "single value cannot be determined" error.
How should I fix this?
Sorry I think I misplaced the brackets
Try this one
Status Finished Date = CALCULATE ( MIN ( 'Work Status'[Date From] ), FILTER ( ALLEXCEPT ( 'Work Status', 'Work Status'[item id] ), 'Work Status'[Status] = "Finished" ) )
You are absolutely briliant!!! Thank you!!!