Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would like PowerBI to calculate the delta between the Budget and the GP per month and per year.
The calender, budget and GP are in different tables.
Could anybody help me with the DAX formula to calculate this?
Thanks in advance!
Nikolaj
Solved! Go to Solution.
Hi @Anonymous ,
If you have a month slicer or year slicer, just need to create a measure like this:
Diff = SUM(Budget[AMS BUDGET]) - SUM(GP[GP])
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Join Budget and GP both with dates. If needed create a more common dimension and analyze with help from the common dimension
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi,
Hereby the budget sample
The GP stated per orderline in an excel file, powerbi doesnt calculate this.
As you can see the Budget is on month level and the GP can also be sliced on month with a calendar table.
Thanks in advance for any help.
Hi @Anonymous ,
If you have a month slicer or year slicer, just need to create a measure like this:
Diff = SUM(Budget[AMS BUDGET]) - SUM(GP[GP])
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |