If conditional base on drop down list

[Anonymous]

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 functionality.

Thank you for the help.

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

[v-diye-msft · Accepted solution]

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]

"If" is there but it is column-based, calculation happen at row level.  For across row calculation you need to use lookup, earlier etc.

https://docs.microsoft.com/en-us/dax/if-function-dax