topic Lastdate -1 filter in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Lastdate-1-filter/m-p/2848826#M91231 <P>Hi there,&nbsp;</P><P>how to calculate measures with LASTDATE -1, -2, -3 etc (or maxstring) filter?</P><P>&nbsp;</P><P>My basic code seems to be working:</P><P>=CALCULATE(Min('CEN'[Price]);LASTDATE(CEN[Data]))</P><P>&nbsp;</P><P>I've tried like this but no effect.&nbsp;</P><P>=CALCULATE(Min('Ceneo'[Price]);LASTDATE(Ceneo[Data]-1))</P><P>&nbsp;</P><P>Thanks for any help!</P><P>&nbsp;</P> Tue, 18 Oct 2022 10:17:11 GMT harry6810 2022-10-18T10:17:11Z Lastdate -1 filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Lastdate-1-filter/m-p/2848826#M91231 <P>Hi there,&nbsp;</P><P>how to calculate measures with LASTDATE -1, -2, -3 etc (or maxstring) filter?</P><P>&nbsp;</P><P>My basic code seems to be working:</P><P>=CALCULATE(Min('CEN'[Price]);LASTDATE(CEN[Data]))</P><P>&nbsp;</P><P>I've tried like this but no effect.&nbsp;</P><P>=CALCULATE(Min('Ceneo'[Price]);LASTDATE(Ceneo[Data]-1))</P><P>&nbsp;</P><P>Thanks for any help!</P><P>&nbsp;</P> Tue, 18 Oct 2022 10:17:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Lastdate-1-filter/m-p/2848826#M91231 harry6810 2022-10-18T10:17:11Z Re: Lastdate -1 filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Lastdate-1-filter/m-p/2848861#M91233 <LI-CODE lang="markup">Day before = VAR MaxDate = MAX ( Ceneo[Date] ) RETURN CALCULATE ( MIN ( Ceneo[Price] ), Ceneo[Date] = MaxDate - 1 ) </LI-CODE> Tue, 18 Oct 2022 10:33:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Lastdate-1-filter/m-p/2848861#M91233 johnt75 2022-10-18T10:33:00Z Re: Lastdate -1 filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Lastdate-1-filter/m-p/2848881#M91235 <P>Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="240987" data-lia-user-login="johnt75" class="lia-mention lia-mention-user">johnt75</a>&nbsp;!!!</P> Tue, 18 Oct 2022 10:50:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Lastdate-1-filter/m-p/2848881#M91235 harry6810 2022-10-18T10:50:28Z