Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
u4unnicool
Frequent Visitor

Getting last value from multiple columns of same table in rowwise

u4unnicool_0-1653328513710.png

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.

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
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]
)

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
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]
)

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

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

@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 🙂

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.