Forum Discussion
Solved
PreviousMonth returns blank values [DAX]
Hi Community, I have two tables T1 contains values for each store by city and date, and T2 is a date table The problem shows up when trying to return the previous value of the store all returned va...
Hi DataVitalizer,
You can create a measure below:
PreviousMonth = CALCULATE(SUM(Table1[MonthlyValue]),PREVIOUSMONTH('Datetable'[Date]),ALLEXCEPT(Table1,'Table1'[City],'Table1'[Store]))Best Regards,
Qiuyun Yu
Hi DataVitalizer,
You can create a measure below:
PreviousMonth = CALCULATE(SUM(Table1[MonthlyValue]),PREVIOUSMONTH('Datetable'[Date]),ALLEXCEPT(Table1,'Table1'[City],'Table1'[Store]))
Best Regards,
Qiuyun Yu
Qiuyun Yu
Thank you v-qiuyu-msft. I do appreciate your help