How to calculate sales customers in last 2 months from current month using DAX
I used the below DAX:
calculate(distinctcount(customerid), datesinperiod(date[date], eomonth(today(),0), -2, month)
But the result is blank. I don’t know why?
How to calculate sales customers in last 2 months from current month using DAX
I used the below DAX:
calculate(distinctcount(customerid), datesinperiod(date[date], eomonth(today(),0), -2, month)
But the result is blank. I don’t know why?