problem with date

[Giada90]

Hi,

I use a formula like this:

measure = calculate(sum(field),'table'[date]<=31/12/22)

If I use this formula it doesn't work, it seems it doesn't recognise date, how can I do?

The field date is in date format

quantity	date
1	01/03/22
2	07/03/22
3	20/04/22
5	20/3/23
8	3/4/23

[DOLEARY85 · Accepted solution]

Your measure would also work if you change the date of 31/12/22 to date(2022,12,31):

Measure 10 = calculate(sum('Table'[field]),'Table'[date]<=date(2022,12,31))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[DOLEARY85]

Hi 

try a calculated column with:

Column = if('Table'[date] <= date(2022,12,31),CALCULATE(sum('Table'[quantity])),0)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍