Self Joining in DAX

DAX
1

Hi,
Following is a Sample Table that resides in direct query from power bi dataset. so cant be accessed in power query,

I need to create a self join so the product category gets populated where ever its available.

The only option i see is to use DAX to achieve this and my mind has gone blank , on how to approach this scenario

Product Name Product Category
product1
product1 Category1
product2
product2 Category2
product3
product3 Category1
product4
product4 Category3
product5
product5 Category3
product6
product6 Category1
product7
product7 Category3
product8
product9
product10
product 11

I’d really apprecieate your support or guidance for this. Thanks in Advance

2

Hi @jsodhi ,

You can go check the below link hope you find your answerer:

Thanks

3

Hi @jsodhi

Due to inactivity, a response on this post has been tagged as “Solution”.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,.

We hope you’ll give your insights on how we can further improve the Support forum. Thanks!