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,
I have hierarchy table but last values are spilt across many columns based on non empty column. I want to have one column to join Fact table based in code.
Value column should have last value from last non empty column
Please help me in solving this issue.
Expected result
Hi @GURUPRASADB
Check if your columns are BLANK() or "" COALESCE works with BLANK() if you have "" or " " it will not work, but you can use SWITCH instead.
Hi,
I see COALESCE is working for only one column, but I have 6 columns to check.
I tried with Switch also it wont work for multiple columns
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 |
---|---|
44 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |