Calculation by Month and Year using Multiple Columns

[Jackbaz99]

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

[Ashish_Mathur · Accepted solution]

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]

Thanks so much!! Learn something new everyday 🙂

[Ashish_Mathur]

You are welcome.

[lbendlin]

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