Forum Discussion

MattiaMaetini's avatar
3 years ago

Dates compare - issue

Hi all,

I have a problem when I try to compare date from a table (SCHEDE[DataRiferimento]) and a date calculate with a measure [Data_AnnoCorrente]:

 

Importo_Assegnato =
CALCULATE(
SUM('SCHEDE'[Somma di Amount]),
FILTER(SCHEDE, SCHEDE[TipoSpesa] = "Assegnato" && SCHEDE[DataRiferimento] = [Data_AnnoCorrente])
)

 

Filter doesn't work.

I try to do anything: change date type, cast both date to text using FORMAT("YYYY-MM-DD"), cast both to DATE:

 

Importo_Assegnato =
CALCULATE(
SUM('SCHEDE'[Somma di Amount]),
FILTER(SCHEDE, SCHEDE[TipoSpesa] = "Assegnato" && DATE(YEAR(SCHEDE[DataRiferimento]),MONTH(SCHEDE[DataRiferimento]),day(SCHEDE[DataRiferimento])) = Date(YEAR([Data_AnnoCorrente]),MONTH([Data_AnnoCorrente]),DAY([Data_AnnoCorrente])
)))

 

The only way filter works it's create Date and insert data hardcode:

Importo_Assegnato =

CALCULATE(
SUM('SCHEDE'[Somma di Amount]),
FILTER(SCHEDE, SCHEDE[TipoSpesa] = "Assegnato" && SCHEDE[DataRiferimento] = Date(2023,04,14)))

 

Please help me,

 

M