Forum Discussion
Helper IReplicate Excel report in Power BI
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,
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.
1 Reply
v-yuta-msftCommunity Support
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.