undefined

[MarcUrdang]

Hi

Seems like this might be quite complex .. I have a table with sequential dates with a value that is accumulative for many dates .. reaching into months as below .. I want to compare month on month and year on year so I have the following calc which works for the last date in the view .. in this case for Feb.... 

calculate(GP[GP ABS], GP[Date] = max(GP[Date]))   

or this one also works ....

VAR _date = LASTNONBLANK(GP[Date],0)    RETURN  CALCULATE(SUM(GP[DR/(CR) In Period]),FILTER('GP',GP[Date] >= _date))

but now I want another calc showing a value for January22 which would be 1200    

I then need to also show it for 12 month back showing month on month which if I get the above correct will be easy

any thoughts?

01/01/2022 1000

03/01/2022 1200 (200 added on the 3rd)

07/02/2022 800

15/02/2022 1200 (400 added on the 15th)

etc

etc

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523