Forum Discussion

FranMullor's avatar
FranMullor
New Member
6 years ago
Solved

Using Datediff + If with dates in a Measure, not in calculated colum

Hi All!!!

 

I want to use something like this in a measure, not in calculated calumm because of the context, i want to get de vale only in de max of dFecha (date)

 

DiasPendientes =
CALCULATE(IF(MAX(FactProveedores[FechaCobro])>max(dFechas[Fecha]);DATEDIFF(MAX(FactProveedores[Fecha]);MAX(dFechas[Fecha]);DAY);BLANK());FactProveedores[IdOrigen]=-3)
 
de problem here is that the "MAX" doesnt work, so I need to get something like that whitout using the MAX i all the FactProveedores (Supliers)
 
Thanks in advance for the help!
 
🙄
 
 
Data Protection
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    FranMullor ,

     

    You may modify the measure like pattern below:

    DiasPendientes =
CALCULATE (
    IF (
        CALCULATE ( MAX ( FactProveedores[FechaCobro] ); ALL ( FactProveedores ) )
            > CALCULATE ( MAX ( dFechas[Fecha] ); ALL ( dFechas ) );
        DATEDIFF (
            CALCULATE ( MAX ( FactProveedores[Fecha] ); ALL ( FactProveedores ) );
            CALCULATE ( MAX ( dFechas[Fecha] ); ALL ( dFechas ) );
            DAY
        );
        BLANK ()
    );
    FactProveedores[IdOrigen] = -3
)

     

    Community Support Team _ Jimmy Tao

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

3 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi FranMullor 

    it's absolutely unclear what do you want. if try to decomposite it could look like

    DiasPendientes =
var _maxFechaCobro = CALCULATE(MAX(FactProveedores[FechaCobro]);FactProveedores[IdOrigen]=-3)
var _maxFecha = CALCULATE(max(dFechas[Fecha]))
RETURN
IF(_maxFechaCobro > _maxFecha; _maxFechaCobro - _maxFecha; BLANK())
  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    FranMullor ,

     

    You may modify the measure like pattern below:

    DiasPendientes =
CALCULATE (
    IF (
        CALCULATE ( MAX ( FactProveedores[FechaCobro] ); ALL ( FactProveedores ) )
            > CALCULATE ( MAX ( dFechas[Fecha] ); ALL ( dFechas ) );
        DATEDIFF (
            CALCULATE ( MAX ( FactProveedores[Fecha] ); ALL ( FactProveedores ) );
            CALCULATE ( MAX ( dFechas[Fecha] ); ALL ( dFechas ) );
            DAY
        );
        BLANK ()
    );
    FactProveedores[IdOrigen] = -3
)

     

    Community Support Team _ Jimmy Tao

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