How to get previous month values based on Month year column values

[AmitSaini]

Hi Community member,

Need help to get some desired result.

Below is the my dataset.

and I already create a measure to calcualte the values for previous months for column automated. below is the measure:

and my table look like below and that is absoluty fine:

But i want to show previous month data  based on MonthName column [column name shown on first screenshot]  and when i use monthname column on table then previous month data is showing 0. see below pic.

Please suggest. how can i use monthname column to calculate previous months data based on projectname?

[FreemanZ]

hi @AmitSaini ,

try like:

...

VAR pvevious= 

CALCULATE(

SUM(Status[Automated],

EOMONTH(Status[datevalue], 0) = EOMONTH(MAX(Status[datevalue]), -1)

)

...

[AmitSaini]

Hi FreemanZ,

Thanks for you reply.

I tried your suggestion but it won't works when we use monthname column.

[johnt75 · Accepted solution]

Create a date table and mark it as a date table. There's lots of articles and videos on how to do that. Link your date table to the date column in your fact table, and then use columns from your date table in the visuals. Your measure using PREVIOUSMONTH will then work if you change the date column to the date column from the date table.

[AmitSaini]

Hi  johnt75,

Thanks for the suggestion and it works very well. Really appreciate it.