Help dax while adding column

Hi yamina  - you can create two calculated columns using DAX.

Min date =
VAR CurrentDossier = 'YourTable'[N_dossier_NUDOS]
RETURN
IF(
COUNTROWS(FILTER('YourTable', 'YourTable'[N_dossier_NUDOS] = CurrentDossier)) > 1,
CALCULATE(MIN('YourTable'[Date_creation_DACRI]),
ALLEXCEPT('YourTable', 'YourTable'[N_dossier_NUDOS])
),
BLANK()
)

This column checks if the difference between Date_creation_DACRI and Min date is between 0 and 30, and if N_prestation_RGOUV has increased.

Condition retour =
VAR MinDate = 'YourTable'[Min date]
VAR CurrentDate = 'YourTable'[Date_creation_DACRI]
VAR CurrentDossier = 'YourTable'[N_dossier_NUDOS]
VAR CurrentPrestation = 'YourTable'[N_prestation_RGOUV]

VAR PreviousPrestation =
CALCULATE(
MAX('YourTable'[N_prestation_RGOUV]),
FILTER(
'YourTable',
'YourTable'[N_dossier_NUDOS] = CurrentDossier &&
'YourTable'[Date_creation_DACRI] < CurrentDate
)
)

RETURN
IF(
NOT ISBLANK(MinDate) &&
CurrentDate - MinDate >= 0 &&
CurrentDate - MinDate <= 30 &&
CurrentPrestation >= PreviousPrestation + 1,
"Retour dans les 30 jours",
BLANK()
)

replace with your table name as per the model. hope this helps.

Thanks for the reply from rajendraongole1, please allow me to provide another insight.

Hi yamina ,

Please refers to the following steps.

Add an index column to the table in the Power Query editor.

Use the following DAX formulas to create the 'Min date' column and the 'Condition retour' column.

Min date = 
VAR CurrentIndex = [Index]
VAR PreviousDossier = MAXX(FILTER('Table', [Index] = CurrentIndex -1),[N_dossier_NUDOS])
VAR CurrentDossier = 'Table'[N_dossier_NUDOS]
RETURN
IF(
    PreviousDossier = CurrentDossier && CurrentDossier <> BLANK(),
    MINX(FILTER('Table', [N_dossier_NUDOS] = CurrentDossier), [Date_creation_DACRI]),
    BLANK()
)

Condition retour  = 
VAR CurrentIndex ='Table'[Index]
VAR CurrentPresentation = 'Table'[N_prestation_RGOUV]
VAR PreviousPresentation =  MAXX(FILTER('Table', [Index] = CurrentIndex -1), [N_prestation_RGOUV])
RETURN
IFERROR(
    IF( [Date_creation_DACRI] - [Min date] >=0  && [Date_creation_DACRI] - [Min date] <= 30 && CurrentPresentation >= PreviousPresentation +1,
        "Retour dans les 30 jours",
        BLANK()
    ),
    BLANK()
)

The final result is as follows. Hopefully it will meet your needs.

Please see the attahced pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sorry , 

I reformulate my request with more lines in the file. I would like to indicate for the same file number the return condition if the Presta number increases by at least 1 and if the creation date is within 30 days of the date of the 1st file