Arun Hariharan

Arun Hariharan

  • 2.1k
  • 2
  • 162

DAX for calculating previous month sales without date column

Jan 11 2022 6:36 AM

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