Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX - Return First non null Vale

Hi All, I need DAX to return the first non null column cycling through 3 columns, they childs of each other. So starting at GEN_3 as its the lowest child. e.g [currency Gen_1],[currency Gen_2],[cur...
Need Help
  • Stemar_Aubert's avatar
    Stemar_Aubert
    6 years ago

    What about this ?

     

    Measure =
    IF (
        NOT ( ISBLANK ( [currency Gen_1] ) ),
        [currency Gen_1],
        IF ( NOT ( ISBLANK ( [currency Gen_2] ) ), [currency Gen_2], [currency Gen_3] )
    )

Stemar_Aubert's avatar
Stemar_Aubert
Resolver I
6 years ago

What about this ?

 

Measure =
IF (
    NOT ( ISBLANK ( [currency Gen_1] ) ),
    [currency Gen_1],
    IF ( NOT ( ISBLANK ( [currency Gen_2] ) ), [currency Gen_2], [currency Gen_3] )
)