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 :
Hi MahyarTF ,
I have two tables, table1 and table2 some of the details on the Alt Department column has no data, that's why I want to create a new column based from the combination of Alt Department from Table1 and Department from Table2 to produce the column of All Department. Already stablished the relationship of the two tables, only the combining of two columns I'm trying to solve.
Please let me know if this is possible, thank you!
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! 🙂