Forum Discussion
Power Query to compare a column with another table column
Hello,
I wanted to add a new column on Table 2 using power query only (I know how to do it in DAX but I'm not able to select the measure in the column series for Line & Stacked bar chart thus resorting to Power Query)
Table 1
| Parameters | Values | Type |
| Current Year | 2022 | String |
| Current Month | Jan | String |
Table 2
| Category | Month | Year | FirstDate |
| A | Jan | 2022 | 01/01/2022 |
| B | Feb | 2022 | 01/02/2022 |
Table 3
| Month | Year | FirstDate |
| Jan | 2022 | 01/01/2021 |
| Feb | 2022 | 01/02/2022 |
=> Add column "Version" in Table 2
The logic that I want is :
if ( Table 2's First Date <= first date of the month from table 1 (Jan 2022) referring to FirstDate coming from table 3) then "Actual" else "Forecast"
Please can you help me do it via Power Query?
Thank you in advance.
Hi, Anonymous
Based on the information above, try the following steps.
Step 1: Merge Table 2 and Table 3
Step 2: Expand Column
Step 3: Add Conditional Column
Step 4: Delete Extended ColumnPlease refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-angzheng-msft
Community Support
Hi, Anonymous
Based on the information above, try the following steps.
Step 1: Merge Table 2 and Table 3
Step 2: Expand Column
Step 3: Add Conditional Column
Step 4: Delete Extended ColumnPlease refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.