Nested If Statements in Power Query referring to fields from different tables

[Anonymous]

I am using power query to automate a certain process and now I am at the stage where I have to build a table where each column will be based on calculations using inputs from columns from different tables. 

The query written in simple language would be something like this:

If total earnings >0 AND employeestaging.uniondescription != "A" AND employeestaging.uniondescription !="B" AND deductionsummary.union = 0, then "Check" else "Ok")

Any idea how  can do this in Power Query?

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

You can refer the following links to get it:

Power Query method:

Filter Data with Multiple Criteria using Power Query

DAX method:

Combined IF-statements from two different tables

Conditional column based on value from another table with matching values

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[amitchandak]

@Anonymous , if you want to use a column across the table in a power query you need to merge tables

https://radacad.com/pivot-and-unpivot-with-power-bi