Forum Discussion
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],[currency Gen_3]
AUD BGN NULL
USD NULL NULL
CAD EUR HKD
so the column would return currency = BGN
USD
HKD
Thanks for any assistance.
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] )
)
1 Reply
- Stemar_AubertResolver I
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] )
)