Forum Discussion
Solved
Finding the last offered price
As you can see in the attached file. We have the current price and various offers. I want to calculate the following: - The last price offered. - The final price. This is the last price offered or,...
Roli_Bird What is it that you expect to see in the yellow shaded totals? The following measure will sum the final Prices column, resulting in 291.
=CALCULATE(sumx(tblPrices,IF([Latest Offer]<>BLANK(),[Latest Offer],[Actual Price])))
Roli_Bird What is it that you expect to see in the yellow shaded totals? The following measure will sum the final Prices column, resulting in 291.
=CALCULATE(sumx(tblPrices,IF([Latest Offer]<>BLANK(),[Latest Offer],[Actual Price])))
- Thank you very much. 291 is what I expect to see - and that's what your measure calculates.
My next problem is just understanding your measure. You use CALCULATE, without filter and inside CALCULATE you use SUMX in table tblPrices with my original formula as expression.
Could you please explain in two or three sentences how you came up with this measure or how the measure works.
