Please tell me what I'm doing wrong with this DAX formula.
I'm trying to create a report that will include current month and previous month by territory. Unfortunately, i'm getting the same values for both months.
PriorMonth=CALCULATE([Sum of TotalDue]),DATEADD(Table1[Date],<wbr>-1,month))
Table1 =Date table ( Date, Month, year)
Relationship= Table.Date=InternetSale.OrderDate
Current Month=Sum([Amount])
Thanks,
Mx
.
Thank for your assistance..
I'm trying to create a report that will include current month and previous month by territory. Unfortunately, i'm getting the same values for both months.
PriorMonth=CALCULATE([Sum of TotalDue]),DATEADD(Table1[Date],<wbr>-1,month))
Table1 =Date table ( Date, Month, year)
Relationship= Table.Date=InternetSale.OrderDate
Current Month=Sum([Amount])
Thanks,
Mx
.
Thank for your assistance..