Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Net Gains calculation

 

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?

Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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.

2 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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)