How extract column field from another table and insert into 1 st table

[Mahamood0218]

Hi PBI experts ,

i have one requirement how to extract column from table 2 and insert at 1st table 

my out put will like

[ND_Pard]

At first glance, it doesn't appear to be correct.

Assume you have a table named: Sales that contains the columns: DateOfSale and OrderNumber

If you want to return the DateOfSale for OrderNumber = "12345", your Dax LookUpValue function would be:

LookUpValue('Sales'[DateOfSale],'Sales'[OrderNumber],"12345")

Good Luck!

[ND_Pard]

Have you considered using a formula instead of a Power Query.
See the example below:

However, it can also be accomplished using Power Query.

Good Luck 🙂

[Mahamood0218]

I need dax function

[ND_Pard]

Use the Dax LookUpValue function.

[Mahamood0218]

@ND_Pard is this dax function correct?