Forum Discussion

Jackbaz99's avatar
Jackbaz99
Helper I
5 years ago
Solved

Calculation by Month and Year using Multiple Columns

Hi,   Ive been using Power BI for a while now but ive come across an issue that on paper should be simple but i am struggling.   I have a date table & column where it is in date order from 01/01/...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    DPPM should be a measure, not a calculated column formula.  Also, to your visual, drag Year/Month/Date from the Date Table.  Lastly, please modify your measure to:

    DPPM = DIVIDE(SUM('DPPM'[NCR Count]),SUM('DPPM'[Delivered Parts]))*1000000

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

DPPM should be a measure, not a calculated column formula.  Also, to your visual, drag Year/Month/Date from the Date Table.  Lastly, please modify your measure to:

DPPM = DIVIDE(SUM('DPPM'[NCR Count]),SUM('DPPM'[Delivered Parts]))*1000000

Hope this helps.

 

  • Jackbaz99's avatar
    Jackbaz99
    Helper I
    5 years ago

    Thanks so much!! Learn something new everyday 🙂

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      You are welcome.