Net Gains calculation

[Anonymous]

I'm trying to calculate the difference between volumes of two consecutive months in the same year (a net gain/loss). I must keep track of which months are being subtracted as well as the volume difference. For example, I must calculate D7-D2 (Month 2 - Month 1 in 2018). What is the best way to accomplish this?

[mwegener · Accepted solution]

Hi @Anonymous ,

create a Date column and use a MoM (Month over Month) time intelligence calculation (Measure).

PBIX

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

Thanks so much!!

For anyone else who views this, you must use the DATE function to create the date column as such:

DATE('table1[year]','table1[month]',1)