Getting last value from multiple columns of same table in rowwise

[u4unnicool]

I need to have the output like this in dax. The table shows different students and there status in each term i want to calulate the output for their  status in term they last appear here T1, T2,T3 ,T4 and T5 are different terms  and the output is the required one let me know what will be Dax querries to grab last value in the term they appear.

[SpartaBI · Accepted solution]

@u4unnicool in case you mean a calculated column in the model table then:

output = 
SWITCH(
    TRUE(),
    'Table'[T5] <> "" ,'Table'[T5],
    'Table'[T4] <> "" ,'Table'[T4],
    'Table'[T3] <> "" ,'Table'[T3],
    'Table'[T2] <> "",'Table'[T2],
    'Table'[T1] <> "",'Table'[T1]
)

Showcase Report – Contoso By SpartaBI

      

[u4unnicool]

@SpartaBI  your solution worked thank you i added null as blank 

=
SWITCH(
TRUE(),
'Table'[status T5] <> BLANK() ,'Table'[status T5],
'Table'[status T4] <> BLANK() ,'Table'[status T4],
'Table'[status T3] <> BLANK() ,'Table'[status T3],
'Table'[status T2] <> BLANK(),'Table'[status T2],

'Table'[status T1] <> BLANK(),'Table'[status T1]
)

[SpartaBI]

@u4unnicool my pleasure 🙂
Hey, check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂