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/2019 until today which is fine - then essentially data from 2 other locations also in this table against the date they fall on, again no issues here.

 

However I now need to do a calculation across both of the columns to give me a figure by the Month & Year as a total. It currently only works out on the specific day. 

 

 

 

 

 

DPPM = 'DPPM'[NCR Count]/'DPPM'[Delivered Parts]*1000000

 

 

 

 

 

 
 

Thanks

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.

     

4 Replies

  • 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.

     

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Please provide sample data in usable format (not as a picture) and show the expected outcome.