DirectQuery Mode : Get previous value in new column

[Juju123]

Hello, 

I'm work on Power BI DirectQuery mode. I need to create a new column which get previous value group by severals column. 

I can't create index in DirectQuery Mode. 

I created this measurement but it does not retrieve all of the previous date.

Previous_Date = MAXX(FILTER(ALL('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'),CAGC_ADVL_INDICATEURS_ETAPES_WF_REP[Numero de l'operation]<SELECTEDVALUE('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'[Numero de l'operation])&&[Designation article]=SELECTEDVALUE('CAGC_ADVL_INDICATEURS_ETAPES_WF_REP'[Designation article])),CAGC_ADVL_INDICATEURS_ETAPES_WF_REP[WF - Date fin reelle])

The goal is to retrieve the previous date for each Workflow, Article, Article designation, Operation code. 

Thanks for your help 🙂

An example of my data:

WF - Numéro du workflow	Article	Designation article	Code opération	Numero de l'operation	Libellé opération	Date réelle de fin	Previous_Date
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE020	20		05/11/2018 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE030	30		24/10/2018 00:00	05/11/2018 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE070	70		19/12/2018 00:00	05/11/2018 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE090	90		15/11/2018 00:00	19/12/2018 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE099	99		14/09/2023 00:00	19/12/2018 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE110	110		07/11/2018 00:00	14/09/2023 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE140	140		07/11/2018 00:00	14/09/2023 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE150	150		07/11/2018 00:00	14/09/2023 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE160	160		23/11/2018 00:00	14/09/2023 00:00
WF0000000002	46044230AA:F0052	COFFRET DESENSIBILISATION	OPE170	170		07/11/2018 00:00	14/09/2023 00:00
WF0000000002	61903443AA:F0052	ON-BOARD BACKSHELL AND PLUGS	OPE020	20		05/11/2018 00:00	07/11/2018 00:00
WF0000000002	61903443AA:F0052	ON-BOARD BACKSHELL AND PLUGS	OPE030	30		24/10/2018 00:00	07/11/2018 00:00
WF0000000002	61903443AA:F0052	ON-BOARD BACKSHELL AND PLUGS	OPE070	70		19/12/2018 00:00	07/11/2018 00:00
WF0000000002	61903443AA:F0052	ON-BOARD BACKSHELL AND PLUGS	OPE090	90		15/11/2018 00:00	19/12/2018 00:00
WF0000000002	61903443AA:F0052	ON-BOARD BACKSHELL AND PLUGS	OPE099	99		14/09/2023 00:00	19/12/2018 00:00

[lbendlin]

 I need to create a new column which get previous value group by severals column. 

Not sure what "previous value"  means but in Direct Query (or rather Mixed Mode)  you can only create calculated columns from data in the same row.