I have data such as the below
I want to create a formula so that in the event of a Null for Value such as on 01/02/2020 I take the previous Value.
I created the formula
If(Count(Value)=0,Above(Total Only(Value)),Sum(Value)) which yields the below and works until 01/05/2020 in which the output is null because there was no value on 01/04/2020.
I was wondering if anyone had any ideas on a formula that would accomplish this. I know I could accomplish this in the script using a Peek function but I have a need to accomplish it via a formula.
@sunny_talwar was wondering if you maybe had an idea.
Thanks in advance!!
Hi @m_perreault ,
I can't think of a way to do this, you can use the self-referencing (recursive) ability of a measure to refer to itself but you still need to be able to dynamically calculate the range of empty values. In any case I'm curious as to what your use-case is. As you say it is easily solved in the load script, I can't think why you would need to dynamically create a value where one doesn't exist that isn't an aggregate of some kind? It would be good to know more of the context of what you are trying to achieve as there may be another way around the problem.
As I mentioned, I know I am able to do it in the load script.
Because of circumstances my project I am not able to update the load script so I am looking to see if there any ways to do this via a front end formula.
does this mean that the above() function has problems in a table, if filters are applied?
I have an "above()-Problem" as well,
maybe you can have a look here, too?