topic Re: Getting last value from multiple columns of same table in rowwise in DAX Commands and Tips

Getting last value from multiple columns of same table in rowwise

u4unnicool — Mon, 23 May 2022 17:59:38 GMT

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.

Re: Getting last value from multiple columns of same table in rowwise

SpartaBI — Mon, 23 May 2022 18:25:33 GMT

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

Re: Getting last value from multiple columns of same table in rowwise

u4unnicool — Tue, 24 May 2022 00:07:47 GMT

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

Re: Getting last value from multiple columns of same table in rowwise

SpartaBI — Tue, 24 May 2022 07:05:28 GMT

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 🙂