Get Earliest Date of a Group across several Tables

[lulubrinki]

Hello everyone,

can you help me with the following topic?

I have two tables:

DimOutlet

OutletKey	Outletname
1	Outlet1
2	Outlet2
3	Outlet3
4	Outlet4

FactMessageDetails

MessageId	OutletKey	MessageCreationDate
1	1	04-08-2022 13:00:00
2	1	03-08-2022 13:00:00
3	1	01-08-2022 13:30:00
4	2	01-08-2022 13:00:00
5	3	20-07-2022 13:00:00
6	4	03-08-2022 13:00:00
7	4	04-08-2022 13:00:00

What I need is the date where an Outlet sent their FIRST message. I was thinking about adding a column to the "DimOutlet" Table:

OutletKey	Outletname	FirstSentMessage
1	Outlet1	01-08-2022 13:30:00
2	Outlet2	01-08-2022 13:00:00
3	Outlet3	20-07-2022 13:00:00
4	Outlet4	03-08-2022 13:00:00

Can somebody help me creation this column?

Thanks a lot in advance 🙂

[SpartaBI · Accepted solution]

@lulubrinki  you are absolutely right 🙂
Create this calculated column:

FirstSentMessagee = CALCULATE(MIN(FactMessageDetails[MessageCreationDate]))

Solution file to download:
Get Earliest Date of a Group across several Tables 2022-08-04.pbix

      

Showcase Report –Contosoo BySpartaBII

[lulubrinki]

Hi @SpartaBI ,

WORKS! Thanks a million 🙂

Best,
Luisa

[SpartaBI]

@lulubrinki my pleasure :))

Do check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

[SpartaBI]

@lulubrinki got your Kudos now.
my pleasure 🙂
Please don't forget to accept the previous message as a solution for community visibility.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543