Measure sum per month and year

[Anonymous]

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

[amitchandak]

@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.

[Anonymous]

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.

[v-yingjl · Accepted 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.