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.
I created a report that is able to show me amount shipped historically by Month-year.
The problem is when I pivot the data the Month-Year will change and I am not sure how to get the new months into my list sum totals by row.
Currently the step shows this (which will error because I now have 2021-12 to also sum):
= Table.AddColumn(#"Replaced Value", "Addition", each List.Sum({[#"2020-12"], [#"2020-11"], [#"2021-01"], [#"2021-02"], [#"2021-03"], [#"2021-04"], [#"2021-05"], [#"2021-06"], [#"2021-07"], [#"2021-08"], [#"2021-09"], [#"2021-10"], [#"2021-11"]}), type number)
One final question I have. This new month won't show up in my table view visual either. Do I have to go into this report each time to get the new month to be shown in table view?
Thank you for any help/advice.
Chad
Solved! Go to Solution.
= Table.AddColumn(#"Replaced Value", "Addition", each List.Sum(List.Skip(Record.ToList(_))))
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
= Table.AddColumn(#"Replaced Value", "Addition", each List.Sum(List.Skip(Record.ToList(_))))
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |