Have Measure and M-1 Measure in a table with Date as Dimension
Hello,
I am looking for a table that gives me the sum of sales and in another column the sum of M-1 sales. I have a result with rangesum and above, but if I select a Date it's no more working.
Dimension : Date
1st Measure : sum(Sales)
2nd Measure : I try Sum({<[Date.autoCalendar.Date]={"=$(vMONTH)"}, Date=>}Sales) with vMONTH :addmonths(Date, -1) / sum({<Date={"=Date(Date-30, 'M/D/YYYY')"}>}Sales)--> Not working,