I would like to re-create the view below (Excel) in Power BI.
I am calculating movements between values.
The calculations in Excel for the above are:
I have come up with seperate calculations and tables in Power BI, but I would like to have it all in one table.
Any assistance would be appreciated.
Go to Solution.
In general, in power bi desktop you can use similar dax function like SUM(), IF() and FILTER(). For more details, I would suggest you to refer to tutorial and reference doc below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!