topic Create table from slicer to search a dynamic column in other table in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-table-from-slicer-to-search-a-dynamic-column-in-other/m-p/2321640#M58007 <DIV>Hi eveone,</DIV><DIV>&nbsp;</DIV><DIV>DAX formula below is correct :</DIV><DIV><SPAN>Table test = </SPAN><SPAN>CALCULATETABLE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Référentiel : contrats salariés'[contrat Saphyr]</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Code Gaia]</SPAN><SPAN>,</SPAN><SPAN>"Agent"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DISTINCT</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'[Agent]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Référentiel : contrats salariés'[Intégration TW_01/01/2022]</SPAN><SPAN>=</SPAN><SPAN>"NON"</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I would like that the choice of the column "'Référentiel : contrats salariés'[Intégration TW_01/01/2022]" to be dynamic from slicer which contains the date format "dd/mm/yyyy"&nbsp;but which refers to a specific column of another table.</SPAN></DIV><DIV><SPAN>The DAX formula above works but I am obliged to freeze the filter column " 'Référentiel : contrats salariés'[Intégration TW_01/01/2022]"</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>DAX formula&nbsp;below gives no results <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></SPAN></DIV><DIV><SPAN>'Xcplt : libellés en-têtes rapport M-1'[Libellés des en-têtes] is data slicer</SPAN></DIV><DIV><SPAN>Table test = </SPAN><SPAN>CALCULATETABLE</SPAN><SPAN>(</SPAN></DIV><DIV><DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Référentiel : contrats salariés'[contrat Saphyr]</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Code Gaia]</SPAN><SPAN>,</SPAN><SPAN>"Agent"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DISTINCT</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'[Agent]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'</SPAN><SPAN>,</SPAN></DIV></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VAR</SPAN> <SPAN>_Column</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>'Xcplt : libellés en-têtes rapport M-1'[Libellés des en-têtes]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;, </SPAN><SPAN>"01/01/2022"</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Intégration TW_01/01/2022]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,&nbsp;</SPAN><SPAN>"01/02/2022"</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Intégration TW_01/02/2022]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , </SPAN><SPAN>"01/03/2022"</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Intégration TW_01/03/2022]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURN</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;_Column</SPAN><SPAN> = </SPAN><SPAN>"NON"</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>The objective would be to obtain a list of employees according to the date selected in the slicer and which are not integrated (dynamic column according to date slicer).</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thanks for you help.</SPAN></DIV><DIV><SPAN>I wish you a nice day&nbsp; &nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></DIV></DIV> Sun, 06 Feb 2022 13:51:40 GMT Gaston78 2022-02-06T13:51:40Z Create table from slicer to search a dynamic column in other table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-table-from-slicer-to-search-a-dynamic-column-in-other/m-p/2321640#M58007 <DIV>Hi eveone,</DIV><DIV>&nbsp;</DIV><DIV>DAX formula below is correct :</DIV><DIV><SPAN>Table test = </SPAN><SPAN>CALCULATETABLE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Référentiel : contrats salariés'[contrat Saphyr]</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Code Gaia]</SPAN><SPAN>,</SPAN><SPAN>"Agent"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DISTINCT</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'[Agent]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Référentiel : contrats salariés'[Intégration TW_01/01/2022]</SPAN><SPAN>=</SPAN><SPAN>"NON"</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I would like that the choice of the column "'Référentiel : contrats salariés'[Intégration TW_01/01/2022]" to be dynamic from slicer which contains the date format "dd/mm/yyyy"&nbsp;but which refers to a specific column of another table.</SPAN></DIV><DIV><SPAN>The DAX formula above works but I am obliged to freeze the filter column " 'Référentiel : contrats salariés'[Intégration TW_01/01/2022]"</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>DAX formula&nbsp;below gives no results <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></SPAN></DIV><DIV><SPAN>'Xcplt : libellés en-têtes rapport M-1'[Libellés des en-têtes] is data slicer</SPAN></DIV><DIV><SPAN>Table test = </SPAN><SPAN>CALCULATETABLE</SPAN><SPAN>(</SPAN></DIV><DIV><DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Référentiel : contrats salariés'[contrat Saphyr]</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Code Gaia]</SPAN><SPAN>,</SPAN><SPAN>"Agent"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DISTINCT</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'[Agent]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>'Référentiel : contrats salariés'</SPAN><SPAN>,</SPAN></DIV></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VAR</SPAN> <SPAN>_Column</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>'Xcplt : libellés en-têtes rapport M-1'[Libellés des en-têtes]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;, </SPAN><SPAN>"01/01/2022"</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Intégration TW_01/01/2022]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,&nbsp;</SPAN><SPAN>"01/02/2022"</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Intégration TW_01/02/2022]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , </SPAN><SPAN>"01/03/2022"</SPAN><SPAN>, </SPAN><SPAN>'Référentiel : contrats salariés'[Intégration TW_01/03/2022]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURN</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;_Column</SPAN><SPAN> = </SPAN><SPAN>"NON"</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>The objective would be to obtain a list of employees according to the date selected in the slicer and which are not integrated (dynamic column according to date slicer).</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thanks for you help.</SPAN></DIV><DIV><SPAN>I wish you a nice day&nbsp; &nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></DIV></DIV> Sun, 06 Feb 2022 13:51:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-table-from-slicer-to-search-a-dynamic-column-in-other/m-p/2321640#M58007 Gaston78 2022-02-06T13:51:40Z Re: Create table from slicer to search a dynamic column in other table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-table-from-slicer-to-search-a-dynamic-column-in-other/m-p/2322217#M58019 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="311555" data-lia-user-login="Gaston78" class="lia-mention lia-mention-user">Gaston78</a> , You can not use slicer values in a calculated table.</P> <P>&nbsp;</P> <P>Only a var table inside measure can get those values</P> Mon, 07 Feb 2022 03:45:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-table-from-slicer-to-search-a-dynamic-column-in-other/m-p/2322217#M58019 amitchandak 2022-02-07T03:45:09Z