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,
I am trying to get a Power BI version of this excel formula
December 2020 | January 2021 |
100 | =B2+SUMIF(....) |
200 | B3+SUMIF(....) |
Currently I have a table with the December 2020 values and another table with the values from Jan 2021-Dec2021
Is there a way to add the December values to January and the sum of that to Februrary and so on?
I assume it may have to do with creating calculated columns?
Thank you in advance!
Hi @Anonymous ,
What is the data structure of values in Dec 2020?Does Dec 2020 only have 2 values?How to add the values to 2021?Are the values added correspondly on each row?
If possible,could you pls provide some sample data with expected output?I would help to create the calculated column.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Looks like you should unpivot all your month columns and then create a running total measure.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |