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 Good Morning,
I have a formula from excel that I can't seem to find a way to put in my formula in power BI. Sorry not really sure on how power BI works till now.
here's the formula : = =SUM(AH2:AK2,AN2)+IF(AF2="O",AO2,0). Anyone can help to solve this pls?
here's the table:
Solved! Go to Solution.
In Power Query, add a custom column.
[AH] + [AI] + any other columns + (if [AF2] = "O" then [AO2] else 0)
Make sure that the columns have the correct datatypes
In Power Query, add a custom column.
[AH] + [AI] + any other columns + (if [AF2] = "O" then [AO2] else 0)
Make sure that the columns have the correct datatypes
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.