Make a current month chart run until the end of the month

[etiennemichelet]

Hi,

I'm looking to make a line chart for the current month with cumulative values of : Revenue, Revenue last year, and Forecast. I have managed to do it but all the lines end where the data ends, which currently is the 15/12/19. Is there a way to have the data continue until the end of month?

This is what I have:

This is what I want to have:

Is there a way to do this please?

Thanks

[etiennemichelet]

Thanks,

Both of those options worked but the data still ended when the data ended.

I instead created a table for the whole current month and filled the data cumulatively in there.

Thanks for your help!

[v-shex-msft]

HI @etiennemichelet,

If these records do not exist in your table, formula calculation will stop at the last records and not expand records. I'd like to suggest adding a calendar with full date values(use calendar date as axis), then you can calculate through original tables based on current calendar date.

Understanding DAX Auto-Exist 

Cumulative Total 

Regards,

Xiaoxin Sheng

[v-shex-msft]

HI @etiennemichelet,

You can also try to use the following measure formula if it meets for your requirement:

Monthly Rolling=
VAR currDate =
    MAX ( table[Date] )
RETURN
    CALCULATE (
        SUM ( table[Amount] ),
        FILTER (
            ALLSELECTED ( Table ),
            YEAR ( Table[Date] ) = YEAR ( currDate )
                && MONTH ( Table[Date] ) = MONTH ( currDate )
                && Table[Date] <= currDate
        )
    )

If above not help, can you please share some dummy data with a similar data structure for test? 

How to Get Your Question Answered Quickly 

Regards,
Xiaoxin Sheng

[amitchandak]

Try

Cummalative ytd = TOTALYTD(sum(Sales[Sales Amount]),filter(all(Sales[Sales Date]),Sales[Sales Date]<=maxx('Date',('Date'[Date Filer]))),"12/31")

Cummalative lytd = TOTALYTD(sum(Sales[Sales Amount]),filter(all(Sales[Sales Date]),Sales[Sales Date]<=maxx('Date',DATEADD('Date'[Date Filer],-1,YEAR))),"12/31")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601