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.

     

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.