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.
I have monthly budget production data, actual daily production data, prod category and prod location. I'm trying to compare budget vs actual production. The budget prod figure is in months whereas Actual production data is daily. 1) How do I sum up actual production by month so I can compare to budget prod figure? 2) Also I need to compare monthly budget to monthly actual by product category and also product factory (multiple locations). I'm 1 month-old new to Power Bi, and i'm struggling to produce a report for work. All help is appreciated!
Solved! Go to Solution.
Hi @Jacklyn ,
I have built a data sample:
1. Production by each month:
Monthly Production = CALCULATE(SUM('Table'[Actual production]),ALLEXCEPT('Table','Table'[Date].[Year],'Table'[Date].[Month]))
2. Production by each month , each category and each factory:
Monthly Production by category & factory = CALCULATE(SUM('Table'[Actual production]),ALLEXCEPT('Table','Table'[Date].[Year],'Table'[Date].[Month],'Table'[Product Category],'Table'[Product Factory]))
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Jacklyn ,
I have built a data sample:
1. Production by each month:
Monthly Production = CALCULATE(SUM('Table'[Actual production]),ALLEXCEPT('Table','Table'[Date].[Year],'Table'[Date].[Month]))
2. Production by each month , each category and each factory:
Monthly Production by category & factory = CALCULATE(SUM('Table'[Actual production]),ALLEXCEPT('Table','Table'[Date].[Year],'Table'[Date].[Month],'Table'[Product Category],'Table'[Product Factory]))
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you heaps Eyelyn!
In Power Query (Home=>Transform),
Thank you too for this solution 😃
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.