topic How to get previous month values based on Month year column values in DAX Commands and Tips

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

AmitSaini — Mon, 02 Dec 2024 10:08:23 GMT

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?

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

johnt75 — Mon, 02 Dec 2024 12:17:52 GMT

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.