0
Answer

DAX for calculating previous month sales without date column

Photo of Arun Hariharan

Arun Hariharan

3y
1.1k
1

Hi Dhruvin

I want the DAX for calculating previous month sales in sales fact table without date column and having only year and month column in the table

Also it should handle if month is 1 then previous month: 12 and not 0

 

Regards

Arun