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

Question

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?

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
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

Forum Discussion

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

2 Replies

Related content

Difference between Reference and Duplicate

OR Statement ?

dynamic reference line

Different schema into different destination

SQL Statement opcion error