Forum Discussion

Bebecirux's avatar
Bebecirux
Frequent Visitor
3 years ago
Solved

the last result

Hi olgad good afternoon

I have a problem with the last fob size, it should give me the last one, but in some cases the month is repeated and then it adds them, how can I do so that it gives me only 1 value

 

 

 

 

dax: measures

 

Ultimo FOB =
VAR UltimaFechaFOB =
    CALCULATE(
        MAX(CostosXProveedor[Fecha]),
        ALL(CostosXProveedor[FOB])
    )

RETURN
    CALCULATE(
        SUM(CostosXProveedor[FOB]),
        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaFOB
       
    ))
 

How should I complete my measurement only so that it brings me the last value and does not add me

thank you so much

Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago
    Ultimo FOB =
VAR UltimaFechaFOB =
    CALCULATE(
        MAX(CostosXProveedor[Fecha]),
        ALL(CostosXProveedor[FOB])
    )

RETURN
    CALCULATE(
        MAX(CostosXProveedor[FOB]),
        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaFOB
       
    ))

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago
    Ultimo FOB =
VAR UltimaFechaFOB =
    CALCULATE(
        MAX(CostosXProveedor[Fecha]),
        ALL(CostosXProveedor[FOB])
    )

RETURN
    CALCULATE(
        MAX(CostosXProveedor[FOB]),
        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaFOB
       
    ))