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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Mahmoodul
Helper I
Helper I

Need to calculate single column from multiple column based on MAX ETA

I need to calculate Top most part based on Max eta(eta is nothing but date coulnm), Please, Can anyone help mescreenshot.png

Below output will be required

output.png

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Mahmoodul , for date you can use Max - ETA

 

Comment you can have measure like

 

Measure =
VAR __id = MAX ('Table'[top_most_part] )
VAR __date = CALCULATE ( MAX('Table'[eta] ), ALLSELECTED ('Table' ), 'Table'[top_most_part] = __id )
CALCULATE ( Max ('Table'[comments] ), VALUES ('Table'[top_most_part] ),'Table'[top_most_part] = __id,'Table'[eta] = __date )

 

 

OCB = Sum(Table[OCB])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Mahmoodul
Helper I
Helper I

@amitchandak : Thank you for reply, Its working fine for me.Thanks alot.

amitchandak
Super User
Super User

@Mahmoodul , for date you can use Max - ETA

 

Comment you can have measure like

 

Measure =
VAR __id = MAX ('Table'[top_most_part] )
VAR __date = CALCULATE ( MAX('Table'[eta] ), ALLSELECTED ('Table' ), 'Table'[top_most_part] = __id )
CALCULATE ( Max ('Table'[comments] ), VALUES ('Table'[top_most_part] ),'Table'[top_most_part] = __id,'Table'[eta] = __date )

 

 

OCB = Sum(Table[OCB])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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