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.
v-diye-msft
Community Support
Community SupportHi 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!