Forum Discussion
Value compare using multiple resolution column logic
Not sure if this is best suited for Power Query or even Power BI but I have created some dashboards already based on more simple resolution logic (1 instead of 2 or more). In this scenario, the goal...
Hi Anonymous ,
I would unpviot twice:
1) Unpivot your values columns
2) Unpivot your Resoluitons-columns
3) Merge and fillter
see attached file
Hi Anonymous ,
I would unpviot twice:
1) Unpivot your values columns
2) Unpivot your Resoluitons-columns
3) Merge and fillter
see attached file
ImkeF , I didn't even think about doing the unpivot twice, but that definitely works! Thank you. Hopefully it doesn't create too much of a performance issue.