Forum Discussion

u4unnicool's avatar
u4unnicool
Frequent Visitor
4 years ago
Solved

Getting last value from multiple columns of same table in rowwise

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...
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

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]
)

 


In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

Showcase Report – Contoso By SpartaBI


Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

SpartaBI Logo

  • u4unnicool's avatar
    u4unnicool
    Frequent Visitor
    4 years ago

    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]
    )