Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count same day last month by category

Hi, I have a dataset which have columns as follows:     And I would like to present count of customers by date along with the count value from same day on previous month as follows: ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a month behind measure like given example with help from date table

     

    Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a month behind measure like given example with help from date table

 

Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))