topic Re: DateAdd in DAX Commands and Tips

DateAdd

fabianfilth — Fri, 16 Dec 2022 02:08:57 GMT

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, but in the ENDOMONTH function more specifically in the DATEADD function, I get the error "A function DATEADD has been used in a True/False expression that is used as a table filter expression. This is not allowed".

How can I solve that?

thanks in advice

Re: DateAdd

tamerj1 — Fri, 16 Dec 2022 03:28:03 GMT

Hi fabianfilth

please try

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

Re: DateAdd

tamerj1 — Fri, 16 Dec 2022 03:28:05 GMT

Hi fabianfilth

please try

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