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 everyone,
Is there any way that I can do this in Power BI? I want to make column "calculations" using this formula.
Thank you in advance,
Milena
Solved! Go to Solution.
Hi @Anonymous ,
Here is a solution to your problem. I am not sure if it is the most efficient solution, but it gives you the result needed.
First, I added an index column from the query editor to the table to be able to catch the previous value of Type and Size. Then, I added a calculated column with the formula below:
Hi @Anonymous ,
Here is a solution to your problem. I am not sure if it is the most efficient solution, but it gives you the result needed.
First, I added an index column from the query editor to the table to be able to catch the previous value of Type and Size. Then, I added a calculated column with the formula below:
Hi @saraMissBI ,
Thank you so much, this works!
I have one additional queston, what should I do if I want to subtract values from column "Number"?
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 |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |