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 functionality.
Thank you for the help.
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.
3 Replies
"If" is there but it is column-based, calculation happen at row level. For across row calculation you need to use lookup, earlier etc.
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.
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!
