Cumulative Total to specific date

Question

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

Cummulative Sold max =

VAR LastSaleDate = CALCULATE(LASTDATE('Forecast Revenue'[Closed Date]),'Forecast Revenue'[Forecast Category] = "sold")

RETURN

IF(SELECTEDVALUE('Date Table'[Date]) >[LastSaleDate] ,

BLANK(),

CALCULATE( 'Key Measures'[Sold],

FILTER(ALLSELECTED('Date Table'),

'Date Table'[Date] <= MAX('Date Table'[Date]) ) ))

amitchandak · Answer

mdgene , Try like
&nbsp;
Cummulative Sold max =VAR LastSaleDate = CALCULATE(LASTDATE('Forecast Revenue'[Closed Date]),filter(allselected('Forecast Revenue'),'Forecast Revenue'[Forecast Category] = "sold"))RETURNCALCULATE( 'Key Measures'[Sold],FILTER(ALLSELECTED('Date Table'),'Date Table'[Date] &lt;= MAX('Date Table'[Date]) &amp;&amp; SELECTEDVALUE('Date Table'[Date]) &gt;[LastSaleDate] ))
&nbsp;
I doubt you are using month from date table in first visual
&nbsp;
or
&nbsp;
Cummulative Sold max =VAR LastSaleDate = CALCULATE(LASTDATE('Forecast Revenue'[Closed Date]),filter(allselected('Forecast Revenue'),'Forecast Revenue'[Forecast Category] = "sold"))RETURNCALCULATE( 'Key Measures'[Sold],FILTER(ALLSELECTED('Date Table'),'Date Table'[Date] &lt;= MAX('Date Table'[Date]) &amp;&amp; SELECTEDVALUE('Date Table'[Date]) &lt; [LastSaleDate] ))

v-lianl-msft · Answer

Hi mdgene&nbsp;,
&nbsp;
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-p/963216&nbsp;
&nbsp;
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.