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 2 tables. One table containing information about my sales (on a daily basis) and one table containing forecast (on a monthly basis). My end goal is to be able to easliy create a top 5 chart for a certain product or certain customer and time-period (could be one month or more) where sales > forecast or sales < forecast.
For this I assume I will need to make a new table and I've created an example in excel of what I need, however I do not know how to apply this in power BI (I assume to create a new table using DAX, but I don't know where to begin).
Solution attached. Always make sure the product table contains all products in Sales and Forecast and that the Customer dimension contains all customers from Sales and Forecast as well. The Time dimension must be a proper Date table covering all the years found in the fact tables in full.
Best
D
Hi @Anonymous
Try these articles
https://www.daxpatterns.com/budget-patterns/
https://www.daxpatterns.com/handling-different-granularities/
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 |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |