Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Good day!
I'm currently having this error with my measure not sure what is the proper syntax. 😞
Solved! Go to Solution.
Hi,
You need the ')' at the end of your code.
It is not closed properly. If you did, use the below code instead :
Hi,
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 @MahyarTF
IT worked now the syntax but it didnt show the result I was expecting.
Basically I want to combine the value of ('asset_inventory asset'[Alt Department]) and ('bhr_collection employee'[department]) in to one column, in the ('asset_inventory asset'[Alt Department]) there are null values that I want to replace it with the value in the ('bhr_collection employee'[department]).
Hi,
Would you please share sample data here ?
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!
Hi,
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! 🙂
Hi,
I don't know what is your purpose with dax. the function VALUES return a table with unique value column.
Hi @HoangHugo
Sorry forgot to state my goal
Basically I want to combine the value of ('asset_inventory asset'[Alt Department]) and ('bhr_collection employee'[department]) in to one column, in the ('asset_inventory asset'[Alt Department]) there are null values that I want to replace it with the value in the ('bhr_collection employee'[department]).
Not sure how to do it really
Hi,
You need the ')' at the end of your code.
It is not closed properly. If you did, use the below code instead :
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |