Is it possible to have a cutoff date in a measurement?
For example, I wanted my efficiency to be shown only from August onwards, then another measurement will show from this month onwards.
In other words, there are two measurements with date division (cutoff date and one with start date)
Hi,
The recommended solution for such a use case is to check the time member from the report context and apply different formulas depending on the period.
The formula could look like this:
CASE WHEN
DateAfterPeriodEnd(DateParse('Aug 01, 2022'),[Time].CurrentHierarchyMember)
THEN
[Measures].[Touch Time ]/[Measures].[Tempo de Vida]
ELSE
-- another formula comes here
END
Kindly,
Janis, eazyBI support
thank you very much @janis.plume