Forum Discussion

bhaskarpbi9999's avatar
bhaskarpbi9999
Helper I
11 months ago
Solved

DAX Lookup value function not working to get matching data from two tables.

Hi ,   I have two tables stage and leads master but need only matching data based on company as i am using stage table data for our dashbaord   Stage Table     Leads Master     ...
Need Help
  • bhaskarpbi9999's avatar
    bhaskarpbi9999
    11 months ago

    Hi Pankajnamekar25,

    I am accepting your solution. thanks and kudos for your support.

     

    Regards,

    Bhaskar

     

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
11 months ago

Hi bhaskarpbi9999, 

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to pankajnamekar25,  for his valuable insights on this thread.

I’m using power query to resolve the issue. I used sample data and successfully reproduced your scenario and got worked on my end. So please look into those images which are I shared below.

You need to replace the value which is shown in the image below:


The outcome shown in the image below:

I attached .pbix file here below so please take a look into that.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

bhaskarpbi9999's avatar
bhaskarpbi9999
Helper I
11 months ago

Hi kpo;oju.

 

Thanks and kudos for your support. I will try the suggested solution.

Regards,

Bhaskar