Hello,
I have 3 tables in the following format and I want to dynamically merge (full outer join) 2 tables at any given time on Fiscal Qtr and Fiscal Month based on paramter that I would like specify in Power BI.
TABLE 1 FORMAT
| Fiscal Qtr | Fiscal Month | Data 1 | Data 2 |
| FY20Q3 | Month 1 | Prod A | X |
| FY20Q3 | Month 1 | Prod B | Y |
| FY20Q3 | Month 1 | Prod C | Z |
TABLE 2 FORMAT
| Fiscal Qtr | Fiscal Month | Data 1 | Data 2 |
| FY20Q3 | Month 2 | Prod A | X |
| FY20Q3 | Month 2 | Prod B | Y |
| FY20Q3 | Month 2 | Prod C | Z |
TABLE 3 FORMAT
| Fiscal Qtr | Fiscal Month | Data 1 | Data 2 |
| FY20Q3 | Month 3 | Prod A | X |
| FY20Q3 | Month 3 | Prod B | X |
| FY20Q3 | Month 3 | Prod C | Z |
The Fiscal Month in the 3 tables are "Month 1", "Month 2" and "Month 3"
I want Power Query to merge on either of following combinations based on user parameters:
ON Table1. Month 1= Table2. Month 2
ON Table1. Month 1= Table3. Month 3
ON Table2. Month 2= Table3. Month 3
How can this be achieved?
