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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JesusMtzN
Regular Visitor

Create table or column with last modified date

Hello good morning.

I have the following related tables, both tables have a field for when they were last modified, the relationship of my main table with the secondary one is one to many.

Diagrama ER.png

 

And I need to create a new table or column within the main table where I can see which two dates are the most recent, taking into account the secondary table may have one or more dates related to a single value from the main table.

2 REPLIES 2
Fowmy
Super User
Super User

@JesusMtzN 

Create a table as follows:

New Table = 
ADDCOLUMNS(
	SUMMARIZE( Orders , Orders[ID_SC] , Orders[Modified_On]) , 
	"Latest Modified Date" , 
		MAX( Orders[Modified_On] , MAXX( RELATEDTABLE( Anotation ) , Anotation[Modified_On] ) )
)




Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thank you very much, it helped me a lot.

How could I implement this formula to create a new column within my main table.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors