https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-a-dynamic-calculated-calendar-table/m-p/4021392#M158666 <P>You should be able to replace the DATE() part with MAX(MAX(Table1[<SPAN>Processing Date]),&nbsp;</SPAN>MAX(Table2[New&nbsp;<SPAN>Processing Date]))</SPAN></P> Wed, 03 Jul 2024 00:00:38 GMT vicky_ 2024-07-03T00:00:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-a-dynamic-calculated-calendar-table/m-p/4021377#M158663 <P>I am trying to make this area (in orange box) dynamic:</P><P><img /></P><P>&nbsp;</P><P>I have uploaded <A href="https://drive.google.com/file/d/16RTw1xkTHAfyJoDGDqGij_ge_8En1m_9/view?usp=sharing" target="_self">my PBI file here</A>:</P><P>&nbsp;</P><P>What I am trying to do is, replacing the static values of "<STRONG>2024, 5, 31</STRONG>" with latest date from one of tables inside PBI file.</P><P>&nbsp;</P><P>So,&nbsp; either get the latest "Processing Date" or "New Processing Date" from either Table_1 or Table_2 and stick the value there instead of "2024, 5, 31".</P><P><img /></P><P>&nbsp;</P><P>Is it possible?</P><P>&nbsp;</P><P>How do I express that?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 02 Jul 2024 23:36:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-a-dynamic-calculated-calendar-table/m-p/4021377#M158663 JustinDoh1 2024-07-02T23:36:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-a-dynamic-calculated-calendar-table/m-p/4021392#M158666 <P>You should be able to replace the DATE() part with MAX(MAX(Table1[<SPAN>Processing Date]),&nbsp;</SPAN>MAX(Table2[New&nbsp;<SPAN>Processing Date]))</SPAN></P> Wed, 03 Jul 2024 00:00:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-make-a-dynamic-calculated-calendar-table/m-p/4021392#M158666 vicky_ 2024-07-03T00:00:38Z