Forum Discussion
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,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.
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
3 Replies
- SpartaBI
Community Champion
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 LogoSpartaBI 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 🙂
