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
joshua1990
Post Prodigy
Post Prodigy

Calculated column based on two related columns

Hey guys!

I need to determine the max value for a specific case.

I have a simple sales table that contains some basic information per order with these columns:

  • Order-Nr (Key column)
  • Step Name
  • Value

This table contains 1 row per order

Then I have a second table that is linked to this table using the Order-Nr and contains some more information:

  • Order-Nr
  • Step Name
  • Status

This table shows me the routing per order and contains several rows per order.

 

Now I would like to add a calculated column into the first table that contains the Max Status for each order and the corresponding step name. The first table already has the latest Step name per Order. I just need to add the latest Status for the order and the latest Step Name

 

 

1 REPLY 1
amitchandak
Super User
Super User

@joshua1990 , Try a new column in Table 1

maxx(filter(Table2, Table2[Order-Nr] = Table1[Order-Nr] && Table2[Step Name] = Table1[Step Name] ),Table2[Status])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.