topic Get Earliest Date of a Group across several Tables in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681089#M80296 <P>Hello everyone,</P><P>&nbsp;</P><P>can you help me with the following topic?</P><P>I have two tables:</P><P>&nbsp;</P><P>DimOutlet</P><TABLE border="1"><TBODY><TR><TD><STRONG>OutletKey</STRONG></TD><TD><STRONG>Outletname</STRONG></TD></TR><TR><TD>1</TD><TD>Outlet1</TD></TR><TR><TD>2</TD><TD>Outlet2</TD></TR><TR><TD>3</TD><TD>Outlet3</TD></TR><TR><TD>4</TD><TD>Outlet4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>FactMessageDetails</P><TABLE border="1"><TBODY><TR><TD>MessageId</TD><TD>OutletKey</TD><TD>MessageCreationDate</TD></TR><TR><TD>1</TD><TD>1</TD><TD>04-08-2022 13:00:00</TD></TR><TR><TD>2</TD><TD>1</TD><TD>03-08-2022 13:00:00</TD></TR><TR><TD>3</TD><TD>1</TD><TD><EM><STRONG>01-08-2022 13:30:00</STRONG></EM></TD></TR><TR><TD>4</TD><TD>2</TD><TD><EM><STRONG>01-08-2022 13:00:00</STRONG></EM></TD></TR><TR><TD>5</TD><TD>3</TD><TD><EM><STRONG>20-07-2022 13:00:00</STRONG></EM></TD></TR><TR><TD>6</TD><TD>4</TD><TD><EM><STRONG>03-08-2022 13:00:00</STRONG></EM></TD></TR><TR><TD>7</TD><TD>4</TD><TD>04-08-2022 13:00:00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>What I need is the date where an Outlet sent their FIRST message. I was thinking about adding a column to the "DimOutlet" Table:</P><TABLE border="1"><TBODY><TR><TD><STRONG>OutletKey</STRONG></TD><TD><STRONG>Outletname</STRONG></TD><TD><STRONG>FirstSentMessage</STRONG> <STRONG><BR /></STRONG></TD></TR><TR><TD>1</TD><TD>Outlet1</TD><TD>01-08-2022 13:30:00</TD></TR><TR><TD>2</TD><TD>Outlet2</TD><TD>01-08-2022 13:00:00</TD></TR><TR><TD>3</TD><TD>Outlet3</TD><TD>20-07-2022 13:00:00</TD></TR><TR><TD>4</TD><TD>Outlet4</TD><TD>03-08-2022 13:00:00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can somebody help me creation this column?</P><P>Thanks a lot in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">πŸ™‚</span></P> Thu, 04 Aug 2022 08:59:36 GMT Anonymous 2022-08-04T08:59:36Z Get Earliest Date of a Group across several Tables https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681089#M80296 <P>Hello everyone,</P><P>&nbsp;</P><P>can you help me with the following topic?</P><P>I have two tables:</P><P>&nbsp;</P><P>DimOutlet</P><TABLE border="1"><TBODY><TR><TD><STRONG>OutletKey</STRONG></TD><TD><STRONG>Outletname</STRONG></TD></TR><TR><TD>1</TD><TD>Outlet1</TD></TR><TR><TD>2</TD><TD>Outlet2</TD></TR><TR><TD>3</TD><TD>Outlet3</TD></TR><TR><TD>4</TD><TD>Outlet4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>FactMessageDetails</P><TABLE border="1"><TBODY><TR><TD>MessageId</TD><TD>OutletKey</TD><TD>MessageCreationDate</TD></TR><TR><TD>1</TD><TD>1</TD><TD>04-08-2022 13:00:00</TD></TR><TR><TD>2</TD><TD>1</TD><TD>03-08-2022 13:00:00</TD></TR><TR><TD>3</TD><TD>1</TD><TD><EM><STRONG>01-08-2022 13:30:00</STRONG></EM></TD></TR><TR><TD>4</TD><TD>2</TD><TD><EM><STRONG>01-08-2022 13:00:00</STRONG></EM></TD></TR><TR><TD>5</TD><TD>3</TD><TD><EM><STRONG>20-07-2022 13:00:00</STRONG></EM></TD></TR><TR><TD>6</TD><TD>4</TD><TD><EM><STRONG>03-08-2022 13:00:00</STRONG></EM></TD></TR><TR><TD>7</TD><TD>4</TD><TD>04-08-2022 13:00:00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>What I need is the date where an Outlet sent their FIRST message. I was thinking about adding a column to the "DimOutlet" Table:</P><TABLE border="1"><TBODY><TR><TD><STRONG>OutletKey</STRONG></TD><TD><STRONG>Outletname</STRONG></TD><TD><STRONG>FirstSentMessage</STRONG> <STRONG><BR /></STRONG></TD></TR><TR><TD>1</TD><TD>Outlet1</TD><TD>01-08-2022 13:30:00</TD></TR><TR><TD>2</TD><TD>Outlet2</TD><TD>01-08-2022 13:00:00</TD></TR><TR><TD>3</TD><TD>Outlet3</TD><TD>20-07-2022 13:00:00</TD></TR><TR><TD>4</TD><TD>Outlet4</TD><TD>03-08-2022 13:00:00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can somebody help me creation this column?</P><P>Thanks a lot in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">πŸ™‚</span></P> Thu, 04 Aug 2022 08:59:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681089#M80296 Anonymous 2022-08-04T08:59:36Z Re: Get Earliest Date of a Group across several Tables https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681164#M80301 <P>Anonymous</LI-USER>&nbsp;&nbsp;you are absolutely&nbsp;right <span class="lia-unicode-emoji" title=":slightly_smiling_face:">πŸ™‚</span><BR />Create this calculated column:</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">FirstSentMessagee = CALCULATE(MIN(FactMessageDetails[MessageCreationDate]))</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Solution file to download:<BR /><A href="https://spartabiltd-my.sharepoint.com/:u:/g/personal/avishayf_spartabi_com/Eaqdtt_IRFVEvt4uTJrqefoBRq3WBeQkM1hiv-BBHxg8Xw?e=nm2JrE" target="_blank" rel="noopener">Get Earliest Date of a Group across several Tables 2022-08-04.pbix</A></P><P><BR /><img /></P><P><BR /><A href="https://www.spartabi.com" target="_blank" rel="noopener"><img /></A><BR /><BR /><A href="https://www.spartabi.com" target="_blank" rel="noopener"><img /></A>&nbsp;&nbsp;&nbsp;<A href="https://www.linkedin.com/company/spartabi" target="_blank" rel="noopener"><img /></A> &nbsp;&nbsp;<A href="https://www.facebook.com/SpartaBI" target="_blank" rel="noopener"><img /></A><BR /><BR /><A href="https://community.powerbi.com/t5/Data-Stories-Gallery/Contoso-by-SpartaBI/m-p/2449543" target="_blank" rel="noopener"><FONT size="4" color="#0000EE">Showcase Report –Contosoo BySpartaBII</FONT></A></P> Thu, 04 Aug 2022 09:22:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681164#M80301 SpartaBI 2022-08-04T09:22:25Z Re: Get Earliest Date of a Group across several Tables https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681846#M80334 <P>Anonymous</LI-USER>&nbsp;got your Kudos now.<BR />my pleasure <span class="lia-unicode-emoji" title=":slightly_smiling_face:">πŸ™‚</span><BR />Please don't forget to accept the previous message as a solution for community visibility.<BR />P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.&nbsp;Please give it a thumbs up over there if you liked it <span class="lia-unicode-emoji" title=":slightly_smiling_face:">πŸ™‚</span><BR /><A href="https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543" target="_blank">https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543</A></P> Thu, 04 Aug 2022 13:38:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681846#M80334 SpartaBI 2022-08-04T13:38:57Z Re: Get Earliest Date of a Group across several Tables https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681861#M80336 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="377293" data-lia-user-login="SpartaBI" class="lia-mention lia-mention-user">SpartaBI</a> ,</P><P>WORKS! Thanks a million <span class="lia-unicode-emoji" title=":slightly_smiling_face:">πŸ™‚</span></P><P>&nbsp;</P><P>Best,<BR />Luisa</P> Thu, 04 Aug 2022 13:41:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681861#M80336 Anonymous 2022-08-04T13:41:53Z Re: Get Earliest Date of a Group across several Tables https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681892#M80338 <P>Anonymous</a>&nbsp;my pleasure :))</P><P><SPAN>Do check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.&nbsp;Please give it a thumbs up over there if you liked it&nbsp;</SPAN><SPAN class="lia-unicode-emoji"><span class="lia-unicode-emoji" title=":slightly_smiling_face:">πŸ™‚</span></SPAN><BR /><A href="https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543" target="_blank" rel="noopener">https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543</A></P> Thu, 04 Aug 2022 13:49:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Earliest-Date-of-a-Group-across-several-Tables/m-p/2681892#M80338 SpartaBI 2022-08-04T13:49:34Z