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 have a table, with following structure. Last column prices Diff is what I would like to extract . The table consists of multiple Source , The prices are captured from Source either in Actual Values or in differential. Source "A" is the base line, Source "B" Price should be reflected as difference from Source "A " e.g. For Month "A" = Month" B" , Price Diff should be , Price "A" - Price "B". prices for Source " C" since already available as differntial should get populated from Price column as is. Is it possible to achieve this using Subtraction function between rows in same table. Thanks fpr your help in advance
Source | Price | Month | Price Diff |
A | 32 | Jul-20 | 32 |
A | 34 | Aug-20 | 34 |
A | 36.5 | Sep-20 | 36.5 |
A | 38.3 | Oct-20 | 38.3 |
B | 33 | Aug-20 | 1 |
B | 32 | Sep-20 | 4.5 |
B | 37 | Oct-20 | 1.3 |
B | 32.5 | Nov-20 | -32.5 |
C | 0.23 | Jul-20 | 0.23 |
C | 2.35 | Aug-20 | 2.35 |
C | -2.34 | Sep-20 | -2.34 |
Solved! Go to Solution.
Hi @Anonymous ,
You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dax, Zoe, Many thanks for your help. It worked just fine.
However, I have a question, I noticed that you used Two Tables . The difference is extracted as a measure in Table (2) , so is there specific reason that you have summarized data in another table Table 2.
This could be too much to ask but if you could explain the measure that you have used. I wonder how you are moving between differnt rows , there isnt a counter used nor an index .
Thanks Again
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |