Power Bi DAX function to M

[Anonymous]

Hello everyone,

I have a small issue, I created a column trough a lookupvalue directly in Power BI and I want to move it into Power Query because I need it for further processing. I'm kind of new to Power BI and still struggling with basic concepts.

Dim3 = LOOKUPVALUE('Dimension Set Entry'[DimensionValueCode],'Dimension Set Entry'[Dimension_Set_ID],'GL Entry'[Dimension_Set_ID], 'Dimension Set Entry'[Dimension_Code],LOOKUPVALUE('GenLedgSetup'[Shortcut_Dimension_3_Code],GenLedgSetup[Primary_Key],""))

I've got a table for GL Entries, one for Dimension Set Entries and the General Ledger Setup table where I get my Dimension code "PL".

For simplicity the last LOOKUPVALUE can be replaced with "PL".

LOOKUPVALUE('GenLedgSetup'[Shortcut_Dimension_3_Code],GenLedgSetup[Primary_Key],"")  ==   "PL".

I have no idea how to perform a lookupvalue for 2 columns in M language in Power Query with searchValues from 2 different table ( GL Entry  and GenLedgSetup ).

I would highly appreciate if anyone can help me with that.

Thanks for your time and for your patience.

Hope you have a great day!

[Anonymous · Accepted solution]

In Power Query you don't (need to) perform a lookup. You perform a JOIN the way SQL joins are performed. There are myriads of vids about Power Query for all levels of advancement on YouTube. One such vid is How to Merge Tables with Power Query: VLOOKUP Alternative - YouTube