Overlaying running month on top of last months data.

[Anonymous]

Hi all,

I cannot figure out a way how to overlay current month's cumulative data on last month's in one graph.

Please take a look at the graph I made in Excel:

So let's say today is 11th of December, 2018. I would like to make a graph, that shows all of the revenues for November and it's overlaid with the current months data. So we could see if are under or ever performing compared to the last month.

Previously I used DATEADD() function, that worked fine for comparing Current Month to Date and Last Month, but it does not work in the graph.

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[v-piga-msft]

Hi @Anonymous,

I have a little confused about your scenario.

By my tests, if we have calculated the value of Last Month and the value the currnet Month, when we drag the Last Month and Current Month value to Line chart, it should show your desired output.

If I misunderstand your scenario, could you share some data sample and your desired output so that we could help further on it.

Best Regards,

Cherry