Conditionally Merge using PowerQuery

Hi All

In the below, I currently have one dimension and one fact table. I have temporarily used the RELATED formula in PowerPivot to join the comments (along with some logic so it only appears once) but the problem of (blank) comes up which I want to hide.

Instead of using PowerPivot, I was thinking of merging the two tables through PowerQuery so I can use [space] to hide the blanks. My issue is how to only merge the tables when index column = min column. Otherwise, leave it blank so it won't repeat itself when I do the PivotTable.

Thanks!!


Data.PNG

PQ.PNG

You can add a conditional column to add Y where those two columns match and then filter out anything that doesn’t contain Y. There are probably more efficient approaches, however I’m away from my PC at the moment.

Yes, I think I misread slightly. However, you should be able to do it with a merge, I’d have thought. I’ll have a look when I’m back at my PC if nobody chips in.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.