Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |