topic DirectQuery Mode : Get previous value in new column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DirectQuery-Mode-Get-previous-value-in-new-column/m-p/3431056#M130090 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I'm work on Power BI DirectQuery mode. I need to create a new column which get previous value group by severals column.&nbsp;</P><P>I can't create index in DirectQuery Mode.&nbsp;</P><P>I created this measurement but it does not retrieve all of the previous date.</P><P>&nbsp;</P><LI-CODE lang="markup">Previous_Date = MAXX(FILTER(ALL('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'),CAGC_ADVL_INDICATEURS_ETAPES_WF_REP[Numero de l'operation]&lt;SELECTEDVALUE('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'[Numero de l'operation])&amp;&amp;[Designation article]=SELECTEDVALUE('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'[Designation article])),CAGC_ADVL_INDICATEURS_ETAPES_WF_REP[WF - Date fin reelle])</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>The goal is to retrieve the previous date for each Workflow, Article, Article designation, Operation code.&nbsp;</P><P>&nbsp;</P><P>Thanks for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P><U><STRONG>An example of my data:</STRONG></U></P><TABLE><TBODY><TR><TD>WF - Numéro du workflow</TD><TD>Article</TD><TD>Designation article</TD><TD>Code opération</TD><TD>Numero de l'operation</TD><TD>Libellé opération</TD><TD>Date réelle de fin</TD><TD>Previous_Date</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE020</TD><TD>20</TD><TD>&nbsp;</TD><TD>05/11/2018 00:00</TD><TD>&nbsp;</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE030</TD><TD>30</TD><TD>&nbsp;</TD><TD>24/10/2018 00:00</TD><TD>05/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE070</TD><TD>70</TD><TD>&nbsp;</TD><TD>19/12/2018 00:00</TD><TD>05/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE090</TD><TD>90</TD><TD>&nbsp;</TD><TD>15/11/2018 00:00</TD><TD>19/12/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE099</TD><TD>99</TD><TD>&nbsp;</TD><TD>14/09/2023 00:00</TD><TD>19/12/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE110</TD><TD>110</TD><TD>&nbsp;</TD><TD>07/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE140</TD><TD>140</TD><TD>&nbsp;</TD><TD>07/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE150</TD><TD>150</TD><TD>&nbsp;</TD><TD>07/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE160</TD><TD>160</TD><TD>&nbsp;</TD><TD>23/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE170</TD><TD>170</TD><TD>&nbsp;</TD><TD>07/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE020</TD><TD>20</TD><TD>&nbsp;</TD><TD>05/11/2018 00:00</TD><TD>07/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE030</TD><TD>30</TD><TD>&nbsp;</TD><TD>24/10/2018 00:00</TD><TD>07/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE070</TD><TD>70</TD><TD>&nbsp;</TD><TD>19/12/2018 00:00</TD><TD>07/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE090</TD><TD>90</TD><TD>&nbsp;</TD><TD>15/11/2018 00:00</TD><TD>19/12/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE099</TD><TD>99</TD><TD>&nbsp;</TD><TD>14/09/2023 00:00</TD><TD>19/12/2018 00:00</TD></TR></TBODY></TABLE> Thu, 14 Sep 2023 13:17:57 GMT Juju123 2023-09-14T13:17:57Z DirectQuery Mode : Get previous value in new column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DirectQuery-Mode-Get-previous-value-in-new-column/m-p/3431056#M130090 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I'm work on Power BI DirectQuery mode. I need to create a new column which get previous value group by severals column.&nbsp;</P><P>I can't create index in DirectQuery Mode.&nbsp;</P><P>I created this measurement but it does not retrieve all of the previous date.</P><P>&nbsp;</P><LI-CODE lang="markup">Previous_Date = MAXX(FILTER(ALL('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'),CAGC_ADVL_INDICATEURS_ETAPES_WF_REP[Numero de l'operation]&lt;SELECTEDVALUE('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'[Numero de l'operation])&amp;&amp;[Designation article]=SELECTEDVALUE('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'[Designation article])),CAGC_ADVL_INDICATEURS_ETAPES_WF_REP[WF - Date fin reelle])</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>The goal is to retrieve the previous date for each Workflow, Article, Article designation, Operation code.&nbsp;</P><P>&nbsp;</P><P>Thanks for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P><U><STRONG>An example of my data:</STRONG></U></P><TABLE><TBODY><TR><TD>WF - Numéro du workflow</TD><TD>Article</TD><TD>Designation article</TD><TD>Code opération</TD><TD>Numero de l'operation</TD><TD>Libellé opération</TD><TD>Date réelle de fin</TD><TD>Previous_Date</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE020</TD><TD>20</TD><TD>&nbsp;</TD><TD>05/11/2018 00:00</TD><TD>&nbsp;</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE030</TD><TD>30</TD><TD>&nbsp;</TD><TD>24/10/2018 00:00</TD><TD>05/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE070</TD><TD>70</TD><TD>&nbsp;</TD><TD>19/12/2018 00:00</TD><TD>05/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE090</TD><TD>90</TD><TD>&nbsp;</TD><TD>15/11/2018 00:00</TD><TD>19/12/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE099</TD><TD>99</TD><TD>&nbsp;</TD><TD>14/09/2023 00:00</TD><TD>19/12/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE110</TD><TD>110</TD><TD>&nbsp;</TD><TD>07/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE140</TD><TD>140</TD><TD>&nbsp;</TD><TD>07/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE150</TD><TD>150</TD><TD>&nbsp;</TD><TD>07/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE160</TD><TD>160</TD><TD>&nbsp;</TD><TD>23/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>46044230AA:F0052</TD><TD>COFFRET DESENSIBILISATION</TD><TD>OPE170</TD><TD>170</TD><TD>&nbsp;</TD><TD>07/11/2018 00:00</TD><TD>14/09/2023 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE020</TD><TD>20</TD><TD>&nbsp;</TD><TD>05/11/2018 00:00</TD><TD>07/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE030</TD><TD>30</TD><TD>&nbsp;</TD><TD>24/10/2018 00:00</TD><TD>07/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE070</TD><TD>70</TD><TD>&nbsp;</TD><TD>19/12/2018 00:00</TD><TD>07/11/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE090</TD><TD>90</TD><TD>&nbsp;</TD><TD>15/11/2018 00:00</TD><TD>19/12/2018 00:00</TD></TR><TR><TD>WF0000000002</TD><TD>61903443AA:F0052</TD><TD>ON-BOARD BACKSHELL AND PLUGS</TD><TD>OPE099</TD><TD>99</TD><TD>&nbsp;</TD><TD>14/09/2023 00:00</TD><TD>19/12/2018 00:00</TD></TR></TBODY></TABLE> Thu, 14 Sep 2023 13:17:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DirectQuery-Mode-Get-previous-value-in-new-column/m-p/3431056#M130090 Juju123 2023-09-14T13:17:57Z Re: DirectQuery Mode : Get previous value in new column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DirectQuery-Mode-Get-previous-value-in-new-column/m-p/3434237#M130254 <LI-CODE lang="markup"> I need to create a new column which get previous value group by severals column. </LI-CODE> <P>Not sure what "previous value"&nbsp; means but in Direct Query (or rather Mixed Mode)&nbsp; you can only create calculated columns from data in the same row.</P> Sat, 16 Sep 2023 19:08:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DirectQuery-Mode-Get-previous-value-in-new-column/m-p/3434237#M130254 lbendlin 2023-09-16T19:08:17Z