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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Anonymous
Not applicable

add column with value based on filter

I have two tables

OrderID Date
113-okt
214-okt

 

OrderID OrderLine Product Price
11A5
12B4
21A5
22B4
23C2

 

I want to add a column in Table 1 with the name of the product with the highest price. So the table looks like this:

OrderID Date  Product
113-oktA
214-oktA

Which formula should I use?

1 ACCEPTED SOLUTION
manikumar34
Solution Sage
Solution Sage

@Anonymous , 

 

Use something like this with relatioship.

manikumar34_0-1602580276261.png

 

Column = CALCULATE(DISTINCT('Table (4)'[Product ]),FILTER('Table (4)','Table (4)'[Price]=MAX('Table (4)'[Price])))
 
You can use the above DAX on both Calculated column or Measure. 
 
Regards, 
Manikumar
 
If you think tjis is helpful, please Accept as Solution and leave a like.




If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

2 REPLIES 2
manikumar34
Solution Sage
Solution Sage

@Anonymous , 

 

Use something like this with relatioship.

manikumar34_0-1602580276261.png

 

Column = CALCULATE(DISTINCT('Table (4)'[Product ]),FILTER('Table (4)','Table (4)'[Price]=MAX('Table (4)'[Price])))
 
You can use the above DAX on both Calculated column or Measure. 
 
Regards, 
Manikumar
 
If you think tjis is helpful, please Accept as Solution and leave a like.




If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




amitchandak
Super User
Super User

@Anonymous , You can not create a column that uses slicer value. Think how can you use measure in place of that

 

 

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.