Replicate Excel report in Power BI

[PowerEnthusiast]

Hi. 

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.

Kind regards,

[v-yuta-msft · Accepted solution]

@PowerEnthusiast ,

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:

https://www.sqlbi.com/guides/dax/

https://docs.microsoft.com/en-us/dax/sum-function-dax

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.