Forum Discussion
Solved
Comparing Values with Previous not based on Dates
Hi, Relative noobie here. I have checked many existing posts and videos but I am not getting how to approach the problem. I have 2 tables as below, with one-to-many from LOADS.load to HOLDIN...
Simple enough if the rule of "previous load" persists; even the LOADS table is redundant. (rule of "previous load": the max Load less than current Load)
Total = SUM(HOLDINGS[value])
Chg = VAR _prev=CALCULATE([Total],TREATAS(VALUES(LOADS[previous load]),HOLDINGS[load]),REMOVEFILTERS(LOADS[load])) RETURN DIVIDE([Total]-_prev,_prev)