cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erhan_79
Post Prodigy
Post Prodigy

Formula Help

Hi there ;

 

ı need your support to create a column as below ;

 

i have two tables , Table A and Table B , Table A has only order numbers  and Table B has Order numbers and delivery dates.

Table A and Table B has relationship via Order Numbers.

 

i want to create a new colum in Table A named " Last Date " , and  rule will be like that : 

  • write latest delivery date for an each order from Table B to Table A 

Capture-1.JPGCapture-2.JPG

 

thanks in advance for your kind supports

 

1 ACCEPTED SOLUTION
mahoneypat
Super User
Super User

You don't need to add an extra column to your model (it could be done with a measure).  But if you want to add the column, you can use this expression from your Table A.

 

LatestDelDate = CALCULATE(MAX(TableB[Delivery Dates]))

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

1 REPLY 1
mahoneypat
Super User
Super User

You don't need to add an extra column to your model (it could be done with a measure).  But if you want to add the column, you can use this expression from your Table A.

 

LatestDelDate = CALCULATE(MAX(TableB[Delivery Dates]))

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.