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.
Hi @all,
For our report I have following challenge.
For every month I need a sum of forcast. Because there is no column with a date available I only have
the column headers which indicates the month. [See below]
Is there a way that a DAX formular reads these headers and compair it with a time intelligence function in
order to return the forcast value of the current month.
As far as I learned the table is not stable so that the column positions are changing, a VLOOKUP might not
be possible.
Item | Forcast SEP | Forcast OCT |
A | 123 | 321 |
B | 456 | 654 |
C | 789 | 321 |
Thank you so much for your help in advance.
Felix
Solved! Go to Solution.
Hi @Anonymous,
You can go to Query Editor, select Forcast SEP and Forcast OCT columns then click on Unpivot Columns button to get below results:
Then split the Attribute column to get month name in a separate column. After you apply these changes, you can use DAX based on this month column with date table to achieve your requirement.
Best Regards,
Qiuyun Yu
Hi @Anonymous,
You can go to Query Editor, select Forcast SEP and Forcast OCT columns then click on Unpivot Columns button to get below results:
Then split the Attribute column to get month name in a separate column. After you apply these changes, you can use DAX based on this month column with date table to achieve your requirement.
Best Regards,
Qiuyun Yu
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 |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |