Hello,
I need help on how to calculate sum of measure of a meausre
I have a table with Price and Date fields. Below is the table which has Year and Quarter as filters
Price is the sum of Price.Price Previous Quarter is sum of price previous Quarter.
Difference in Price is Difference in Price and Previous Quarters.
Now, I wanted to calculate sum of Difference in Price as shown in Sum of Difference field.
I have been trying to achieve the results using various options like combining all calculation in a single measures, but no sucess yet.
Please help me on how to sum the difference in price. I would appreciate any help/suggestions.
Thank you!!
Measures
Price = SUM(Price)
Price Previous Quarter = CALCULATE([Price], PREVIOUSQUARTER(Date_Table[Date]) )
Difference in Price = Price Previous Quarter - Price
| Year | Quarter | Price | Price Previous Quarter | Difference in Price | Sum of Differences |
| 2018 | Q1 | 967 | 0 | 967 | 967 |
| 2018 | Q2 | 1115 | 967 | 148 | 1115 |
| 2018 | Q3 | 1432 | 1115 | 317 | 1432 |
| 2018 | Q4 | 1455 | 1432 | 23 | 1455 |
| 2019 | Q1 | 1863 | 1455 | 408 | 1863 |
| 2019 | Q2 | 1952 | 1863 | 89 | 1952 |
| 2019 | Q3 | 1988 | 1952 | 36 | 1988 |
| 2019 | Q4 | 2018 | 1988 | 30 | 2018 |
