Forum Discussion
Operator or expression '()' is not supported in this context
Hi,
You need the ')' at the end of your code.
It is not closed properly. If you did, use the below code instead :
Department All = If (SELECTEDVALUE('asset_inventory asset'[Alt Department]) <> "",SELECTEDVALUE('asset_inventory asset'[Alt Department]),SELECTEDVALUE('asset_inventory asset'[Alt Department]))Appreciate your KudosHi,
I have another suggestion :
1- in Power Query, Merge these tables based on the 'Name', and bring the names and Alt Department from Table1 and Department from Table2
2- Add a custom column and use below M query :
if [Alt Department] <> "" and Text.Upper([Alt Department]) <> Text.Upper("null")
then [Alt Department]
else [Sheet143.department]3- then use the created column in your visual :
Memorable MemberHi,
I have another suggestion :
1- in Power Query, Merge these tables based on the 'Name', and bring the names and Alt Department from Table1 and Department from Table2
2- Add a custom column and use below M query :
if [Alt Department] <> "" and Text.Upper([Alt Department]) <> Text.Upper("null")
then [Alt Department]
else [Sheet143.department]
3- then use the created column in your visual :
Thank you so much, it worked! 🙂