October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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
Solved! Go to Solution.
Hi @fabianfilth
please try
=
CALCULATE (
[Costo Total],
'Dim Fecha'[Date] = EOMONTH ( 'Calidad Inventario'[Fecha Cargue], -12 ),
ALL ( 'Dim Fecha' )
)
Hi @fabianfilth
please try
=
CALCULATE (
[Costo Total],
'Dim Fecha'[Date] = EOMONTH ( 'Calidad Inventario'[Fecha Cargue], -12 ),
ALL ( 'Dim Fecha' )
)
Hi @fabianfilth
please try
=
CALCULATE (
[Costo Total],
'Dim Fecha'[Date] = EOMONTH ( 'Calidad Inventario'[Fecha Cargue], -12 ),
ALL ( 'Dim Fecha' )
)
User | Count |
---|---|
30 | |
16 | |
13 | |
12 | |
10 |
User | Count |
---|---|
57 | |
19 | |
11 | |
11 | |
9 |