Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Please I have a measure that shows the cumulative measure upto specific date. But My measure still show values past the date expected. I have added a screen shot of the result below.
If I use date in place of Month it works, but I will like to see it at month level. (screen shot attached). Please what is your advice
This is my dax measure
Hi @mdgene ,
Has the problem been solved? If the problem persists, please delete the sensitive data and provide a sample pbix so that i can do more tests.https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am still on it. I will modify and send over. Thank you
@mdgene , Try like
Cummulative Sold max =
VAR LastSaleDate = CALCULATE(LASTDATE('Forecast Revenue'[Closed Date]),filter(allselected('Forecast Revenue'),'Forecast Revenue'[Forecast Category] = "sold"))
RETURN
CALCULATE( 'Key Measures'[Sold],
FILTER(ALLSELECTED('Date Table'),
'Date Table'[Date] <= MAX('Date Table'[Date]) && SELECTEDVALUE('Date Table'[Date]) >[LastSaleDate] ))
I doubt you are using month from date table in first visual
or
Cummulative Sold max =
VAR LastSaleDate = CALCULATE(LASTDATE('Forecast Revenue'[Closed Date]),filter(allselected('Forecast Revenue'),'Forecast Revenue'[Forecast Category] = "sold"))
RETURN
CALCULATE( 'Key Measures'[Sold],
FILTER(ALLSELECTED('Date Table'),
'Date Table'[Date] <= MAX('Date Table'[Date]) && SELECTEDVALUE('Date Table'[Date]) < [LastSaleDate] ))
Hi , I tested the two query, query 1, was returning blank. while query 2 was behaving just like my query. also I am using the date column. Thank you
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |