Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Thanks so much!! Learn something new everyday 🙂
You are welcome.
Please provide sample data in usable format (not as a picture) and show the expected outcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |