Forum Discussion
Lookup Value Horizontally
How do you Hlookup on Dax or PBI, Say as example I have this table and I have values in horizontal mode, I need to search up the date and matching the date with the header date I need that to bring ...
John1232 , I think you try to use unpivot in power query
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Thank you very much for your answer
The problem is that I need to use the unique value to match this with another table, and when I unpivot this will create duplicates in the unique value and will no longer support a relationship cause it will count as many to many from both tables giving an error.