Forum Discussion
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 values are blank
The formula used in the new calculated column is
Here is the result I am looking for
Thank you in advance.
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
3 Replies
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 YuThank you v-qiuyu-msft. I do appreciate your help
I would suggesting visiting the community to post this in the desktop section or the Dax section as this particular site is for reporting issues with the actual product and not with a calculation.
You may want to include a little more info with the post including a snapshot or your model relationships as well in order to diagnose the calculation issue. It seems that the Dax is having an issue defining last month. It may be the relationship or the field you are adding. Your calculation references your column of [Date] but the display shows DateTable. You may want to try droping [Date] on the visual instead of DateTable.
