https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-lookupvalue-measure/m-p/737815#M2138 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="507" data-lia-user-login="parry2k" class="lia-mention lia-mention-user">parry2k</a>&nbsp;@SAMEPERIODLASTYEAR is for dates, mine is period(text).&nbsp;</P> Thu, 11 Jul 2019 15:47:08 GMT Anonymous 2019-07-11T15:47:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-lookupvalue-measure/m-p/736978#M2090 <P>Hi,</P><P>&nbsp;</P><P>How can I obtain a new measure according to the "CANTIDAD_POSTULANTES" according to the previous period?</P><P>&nbsp;</P><P>image:&nbsp;<A href="https://ibb.co/hBJvxSv" target="_self">https://ibb.co/hBJvxSv</A></P><P>objective:&nbsp;<A href="https://ibb.co/23KmtCr" target="_self">https://ibb.co/23KmtCr</A></P><P>&nbsp;</P><P>thanks.</P> Wed, 10 Jul 2019 22:57:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-lookupvalue-measure/m-p/736978#M2090 Anonymous 2019-07-10T22:57:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-lookupvalue-measure/m-p/737149#M2093 <P>Anonymous</a> you can use DAX function&nbsp;<A href="https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax" target="_self"><STRONG>SamePeriodLastYear</STRONG></A></P> Thu, 11 Jul 2019 05:16:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-lookupvalue-measure/m-p/737149#M2093 parry2k 2019-07-11T05:16:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-lookupvalue-measure/m-p/737815#M2138 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="507" data-lia-user-login="parry2k" class="lia-mention lia-mention-user">parry2k</a>&nbsp;@SAMEPERIODLASTYEAR is for dates, mine is period(text).&nbsp;</P> Thu, 11 Jul 2019 15:47:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-lookupvalue-measure/m-p/737815#M2138 Anonymous 2019-07-11T15:47:08Z