Show current month and previous month in separate visualizations.

[Anonymous]

Hi,

I have a scenario where I would like to display the value for current month in one data card and the value for previous month in another. I would like to be able to just apply the date in the Filter on all pages to update the entire Power Bi since this is a monthly report. The current month should display 0.55 (December) as it does below and the previous month should display 0.39 (November). I am not real sure how to go about solving this issue since and am willing to try whatever.

Thanks in advance for any help!

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

If your date column is contiguous dates,take below steps:

Create a measure as below:

Previous = CALCULATE(SUM('Table'[value]),DATEADD('Table'[date],-1,MONTH))

And you will see:

For the related .pbix file,pls see attached.

Otherwise,first create a calendar table as below:

calendar = CALENDAR(MIN('Table'[date]),MAX('Table'[date]))

And create a relationship between your table and calendar table;

Then create a measure as below:

_Previous = CALCULATE(SUM('Table'[value]),DATEADD('calendar'[Date],-1,MONTH))

 And you will see:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!