Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Hi How to get Value for each Type based on max date from column End_Date
This should be 2 measure, because will use it in card visual separetely
Measure1_Open : value 3 , because max date from End_Date = 31 Mar 2022
Measure2_Closed : value 11, because max date from End_Date = 28 Feb 2022
Go to Solution.
Hi @Delion ,I think standard CALCULATE should work. Something like:Measure1_Open = CALCULATE(SUM('Table'[Value]),LATESTDATE('Table'[End_Date]),'Table'[Type]="Open")The same logic applies for the second measure.I wrote this on my phone so if its not working, let me know and I will re-check from my pc.
View solution in original post
It's solved, I modify it a bit
Measure1_Open = CALCULATE(SUM('Table'[Value]),LASTDATE('Table'[End_Date]),'Table'[Type]="Open")
hmm using LATESTDATE is not working, why use LATESTDATE not MAX?
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.