Forum Discussion
last 3 Days Variance per ID
Hi all, I have a dataset of ID, Date, and value. I am trying to calculate the last 3 values of ID based on the last 3 dates. So once we get the last 3 values based on these trying to write ...
Sure.
Thanks Greg, your reply was really helpful.
The Bucket column in data I am calculated using below formula.
Bucket = Switch ( True(),
And( [Avg Discount %]>=-10 ,[Avg Discount %] < [TMax 5% Var]) , "Green",
And( [Avg Discount %]>=[TMax 5% Var],[Avg Discount %] < [TMax 15% Var]) , "Yellow",
And( [Avg Discount %] >= [TMax 15% Var],[Avg Discount %] < 500), "Red"
)
and I have used the calculated column formula given by you, but I am facing dependency error while applying the formula
Hi anil_power,
Please refer to this blog to avoid A circular Dependency was detected" error.
Best Regards，
Cherry
