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.
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!!!
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 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |