Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 |
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |