Power Query to compare a column with another table column

[Anonymous]

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.

[v-angzheng-msft · Accepted solution]

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 Column

Please 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.