How to create a line with a step change based on date in EazyBI

Questions & Answers
1

Hi all,

I am working in EazyBI and would like to create a goal line, with a step change. Currently, I have a user defined measure that simply equals 0.7 (or 70%). I would like to update this line to equal 0.7 before 8/1/2020 and 0.8 after 8/1/2020. (Basically, I updated my goal from 70% to 80%.

Does anyone know how to achieve this in EazyBI?

Thanks

Lea

2

Hi @leawilliams!

You can do this with the CASE condition and DateCompare(…) function. Please try the following:

CASE WHEN
  DateCompare(
   DateParse("1 Aug 2020"), 
   [Time].CurrentHierarchyMember.StartDate) > 0
THEN 0.7
ELSE 0.8
END

Lauma / support@eazybi.com

3

Thank you Lauma! This worked perfectly.

1 Like