Forum Discussion
Replicate Excel report in Power BI
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.