Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |