Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Problem combining measures on current month and previous month

Hi all,

 

I'm trying to combine two measures on a graph, one wich calculate, at the latest alimentation date, result of current month, another wich calculate, the 2nd of current month, result of previous month ? 

 

For example, we are 08/05 and my performance of this month (august) is so far of 25%. Previous month performance (july) was calculated 08/02 and is of 80%.

Alimentation dateperformance
08/0280%
08/0525%


Alimentation date is on my x axis, I would like to display 80% in july and 25% in august.

 

Any idea how to achieve this ? I tried using dateadd function but it didn't do anything.

 

Thank you in advance for your help.

Regards,

 

Alice

  • Add a "Target date"  column to your data and use that for the x axis.

2 Replies

  • Add a "Target date"  column to your data and use that for the x axis.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you, I ended up using a calendar table.