Forum Discussion

SaiMadhur's avatar
SaiMadhur
Regular Visitor
5 years ago

Validate each row in a table with all the rows\Conditions in other table in Power Query

Hello! I have a scenario to validate each row in Table 1 with all the conditions in Table 2 to make a decision whether to approve or reject a request in power Query, If the user from Table 1 meets a...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

You cannot do that in DAX as the EVALUATE() command is not available in Power BI Desktop .

You can do this in Power Query with Expression.Evaluate()- but technically this would amount to the creation of yet another meta language.  (if you are interested, read up on the history of LEX and YACC)

 

How many condition are you planning to check for?

  • SaiMadhur's avatar
    SaiMadhur
    Regular Visitor
    5 years ago

    Hello!

     

    Thanks for the quick reply! I see it's getting little complicated, I'll use VBA to solve the problem and will think through LEX and YACC.

     

    We currently have 20 condition to validate and it may increase in future.

     

    Thanks