Forum Discussion

Icon for Post Patron rank

Post Patron

5 years ago

Solved

Current month vs. Previous

Hello,

I would like to create a graph that compares this month with previous month.

I tried already nummerous things but I just can't get it to work.

Here is an image of how I would like it to have.

amitchandak
5 years ago
Niels_T , Stacked visual with this month and last month measure?

examples of measure

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
Tahreem24
5 years ago
Niels_T in order to create previous month values you can create below DAX measure:

Previous Month = CALCULATE (SUM(Table[Value Column]), DATEADD(Table[DateColumn], -1, MONTH))
Tahreem24
5 years ago
Niels_T - Try this Staced bar chart like below:

6 Replies

amitchandak
Super User
5 years ago
Niels_T , Stacked visual with this month and last month measure?

examples of measure

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
- Niels_T
  Post Patron
  5 years ago
  amitchandak Tahreem24
  
  So, I made the measures and they work, however, how do I make sure that my graph displays the current month and compare it with the previous month?
  - Tahreem24
    Super User
    5 years ago
    Niels_T one way to show the current vs. previous value by using Clustered Column chart like below. Means, light blue shows current commission value (random example) and dark blue shows previous month commission.
Tahreem24
Super User
5 years ago
Niels_T in order to create previous month values you can create below DAX measure:

Previous Month = CALCULATE (SUM(Table[Value Column]), DATEADD(Table[DateColumn], -1, MONTH))