https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dudas-con-Lookupvalue/m-p/3432731#M130157 <P>Hola a <A href="mailto:tod@s," target="_blank" rel="noopener">tod@s,</A></P><DIV><DIV><SPAN>LOOKUPVALUE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Foto BI Inicial Detallada'</SPAN><SPAN>[Número documento]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Foto BI Inicial Detallada'</SPAN><SPAN>[Número documento]</SPAN><SPAN>, </SPAN><SPAN>'Foto BI Final Detallada'</SPAN><SPAN>[Número documento]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Foto BI Inicial Detallada'</SPAN><SPAN>[Fecha Foto]</SPAN><SPAN>,</SPAN><SPAN>Date</SPAN><SPAN>(</SPAN><SPAN>2023</SPAN><SPAN>,</SPAN><SPAN>9</SPAN><SPAN>,</SPAN><SPAN>4</SPAN><SPAN>),</SPAN><SPAN>"No"</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Como podría sustituir <FONT size="5"><STRONG>Date(2023,9,4)</STRONG></FONT> por el valor de un filtro seleccionado de 'Foto BI Inicial Detallada'[Fecha Foto]</SPAN></DIV><DIV><SPAN>por el usuario, he intentado con MAX, MIN, y no me funciona...</SPAN></DIV><DIV>&nbsp;</DIV><DIV>Gracias 1000</DIV></DIV> Fri, 15 Sep 2023 10:14:27 GMT Santi_galan 2023-09-15T10:14:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dudas-con-Lookupvalue/m-p/3432731#M130157 <P>Hola a <A href="mailto:tod@s," target="_blank" rel="noopener">tod@s,</A></P><DIV><DIV><SPAN>LOOKUPVALUE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Foto BI Inicial Detallada'</SPAN><SPAN>[Número documento]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Foto BI Inicial Detallada'</SPAN><SPAN>[Número documento]</SPAN><SPAN>, </SPAN><SPAN>'Foto BI Final Detallada'</SPAN><SPAN>[Número documento]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Foto BI Inicial Detallada'</SPAN><SPAN>[Fecha Foto]</SPAN><SPAN>,</SPAN><SPAN>Date</SPAN><SPAN>(</SPAN><SPAN>2023</SPAN><SPAN>,</SPAN><SPAN>9</SPAN><SPAN>,</SPAN><SPAN>4</SPAN><SPAN>),</SPAN><SPAN>"No"</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Como podría sustituir <FONT size="5"><STRONG>Date(2023,9,4)</STRONG></FONT> por el valor de un filtro seleccionado de 'Foto BI Inicial Detallada'[Fecha Foto]</SPAN></DIV><DIV><SPAN>por el usuario, he intentado con MAX, MIN, y no me funciona...</SPAN></DIV><DIV>&nbsp;</DIV><DIV>Gracias 1000</DIV></DIV> Fri, 15 Sep 2023 10:14:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dudas-con-Lookupvalue/m-p/3432731#M130157 Santi_galan 2023-09-15T10:14:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dudas-con-Lookupvalue/m-p/3435347#M130340 <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="220842" data-lia-user-login="Santi_galan" class="lia-mention lia-mention-user">Santi_galan</a>&nbsp;,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;"><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly&nbsp;</A>&nbsp;</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Regards,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Xiaoxin Sheng</P> Mon, 18 Sep 2023 06:16:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dudas-con-Lookupvalue/m-p/3435347#M130340 Anonymous 2023-09-18T06:16:01Z