Forum Discussion
If conditional base on drop down list
In excel, I am able to create a conitional statment base on other cell. For example, =IF($E$1="Statutory",AG2,AF2) And cell E1 is either Statutory or not. I wonder if Power BI has similar ...
Hi Anonymous
You should probably refer to the LOOKUPVALUE function with IF statement, official document for your reference:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
https://docs.microsoft.com/en-us/dax/if-function-dax
That would be helpful if you can disclose your requirement with detailed data and expected results, that I can draw it up for you.
amitchandak
Super User
Super User"If" is there but it is column-based, calculation happen at row level. For across row calculation you need to use lookup, earlier etc.