Is it possible to make a "SECONDNONBLANKVALUE" measure?

[AlexGQc]

Hi,

I'm trying to make something that emulates FIRSTNONBLANKVALUE, but i want it to instead return the nTH value (second, third, fourth...).

I tried a few things but nothing worked right. Is it something that can be done?

(The values are text).

[CNENFRNL]

Hi, @AlexGQc , sure thing, as well as 3rd, 4th, 5th ... NONBLANKVALUE alike. You might want to try this pattern,

Nth_NONBLANKVALUE =
LASTNONBLANKVALUE (
    TOPN ( n, ... ),
    1
)

[daxer-almighty]

Of course, it's possible. With DAX almost anything is possible, bar some recurrent formulae that can't be expressed in a closed form.

To do this, however, you have to create it straight in the model, so it'll be specific to it. You can't create something that will be a general function like FIRSTNONBLANKVALUE. There is no way to define general formulae that would work similarly to the native DAX functions.