Forum Discussion

fabianfilth's avatar
fabianfilth
Regular Visitor
3 years ago
Solved

DateAdd

Hello power bi team,   Can you please give me some help on the following   I want to create a measure that calculates the total cost of the last day of the previous month of the previous year, bu...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi fabianfilth 

    please try

    =
    CALCULATE (
    [Costo Total],
    'Dim Fecha'[Date] = EOMONTH ( 'Calidad Inventario'[Fecha Cargue], -12 ),
    ALL ( 'Dim Fecha' )
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi fabianfilth 

please try

=
CALCULATE (
[Costo Total],
'Dim Fecha'[Date] = EOMONTH ( 'Calidad Inventario'[Fecha Cargue], -12 ),
ALL ( 'Dim Fecha' )
)