https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560805#M72841 <P>I have a measure to return a value of the max date if the slicer is not filtered, however the value is blank:</P><P>Can you help me with this measure, thanks.</P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 06 Jun 2022 09:50:51 GMT rmeng 2022-06-06T09:50:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560805#M72841 <P>I have a measure to return a value of the max date if the slicer is not filtered, however the value is blank:</P><P>Can you help me with this measure, thanks.</P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 06 Jun 2022 09:50:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560805#M72841 rmeng 2022-06-06T09:50:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560926#M72850 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="188484" data-lia-user-login="rmeng" class="lia-mention lia-mention-user">rmeng</a>&nbsp;</P><P>Do you have a year column in the date table?</P> Mon, 06 Jun 2022 10:43:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560926#M72850 tamerj1 2022-06-06T10:43:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560936#M72851 <P>No, despite automatically creates the hierarchie.&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 06 Jun 2022 10:47:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560936#M72851 rmeng 2022-06-06T10:47:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560949#M72852 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="188484" data-lia-user-login="rmeng" class="lia-mention lia-mention-user">rmeng</a>&nbsp;<BR />I would recommend to add a year column but you may also try</P><P><img /></P> Mon, 06 Jun 2022 10:53:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Slicer-not-filtered-returns-the-max-date-available/m-p/2560949#M72852 tamerj1 2022-06-06T10:53:04Z