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
lbendlin's avatar
lbendlin
Super User
6 years ago

Nesting ifs in Power Query is very simplistic

 

if this then that else if this1 then that1 else if this2 then that2 else this3

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
    Super 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])
                )
            ),