Forum Discussion
Helper IHow to get previous month values based on Month year column values
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?
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.
4 Replies
johnt75Super User
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.
