Forum Discussion
Use previous rows for calculation
dear all, I'm in need of a suggestion for how to calculate a column on base of the comparison of previous rows of other columns. My data set is as follows, what I need to calculate is - "(n...
Hi,
This calculated column formula works provided the entries in the "Comm. Cons" column are in ascending order.
(net) Comm. Cons = [Comm. Cons]-CALCULATE(MAX(Data[Comm. Cons]),FILTER(Data,Data[Date]<EARLIER(Data[Date])))Hope this helps.
You are welcome. If my previous reply helped, please mark it as Answer.
done, with pleasure