Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX > M Query - LOOKUPVALUE

Any tips on how to convert this DAX over to M?   The below displays as expected but I need the transformation to occur in Power Query to conduct subsequent steps on the existing [From Date] and gen...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

i meant in the context of utilizing a lookup. that doesnt seem possible with the need to create a function in a separate query for a lookup

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

yes, you can use that inside the function without issues.

 

Here's an example

 

#"Added Custom" = Table.AddColumn(Index, "Match", 
        (k) => Table.SelectRows(#"Assignments",
            each ([AID]="*" or k[AID]=[AID])
                and ([PSA]="*" or k[PSA]=[PSA])
                and ([SID]="*" or k[SID]=[SID])
                )
            ),