User Profile
dbiduk
New Member
Joined 3 years ago
User Widgets
Contributions
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 HOLDINGS.load in order to define the Previous Load given a Load. And this is what I would like to see in a Matrix or Table: I realize I need to do something at the Query level (new column or some DAX expression) but I don't understand how I can add a column to my Holdings table that says something like: Previous Value = HOLDINGS.Value where current.Load = LOADS.Previous Load and current.Holding = HOLDINGS.Holding And then calculating the Chg would be easy enough (Calculated column). Please help!
