Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! 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:
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |