topic Re: What is the difference between these two uses of DATESYTD? in DAX Commands and Tips

What is the difference between these two uses of DATESYTD?

LucasRezende — Wed, 20 May 2020 21:48:29 GMT

Hi there.

I am trying to understand the difference between using:

Entradas YTD = CALCULATE( [Entradas Totais]; DATESYTD( 'dCalendário'[Data] ) )

... and using:

Entradas YTD v2 = CALCULATE( [Entradas Totais]; FILTER( 'dCalendário'; DATESYTD( 'dCalendário'[Data] ) ) )

The first option works, but the second one rises an error saying that multiple values has been supplied. From my understanding DATESYTD returns me a single colun table with dates from the first date of the year of the current context and the last date of the current context, and it will filter table dCalendário, and this filtered dCalendário will filter my measure [Entradas Totais].

Can someone explain to me what concept I am missing?

Thanks in advance.

Re: What is the difference between these two uses of DATESYTD?

mahoneypat — Thu, 21 May 2020 02:08:28 GMT

I'll take a shot at it. While Calculate() and Calculatetable() accept tables as filter arguments, Filter() is an iterator and is looking for an evaluation to do on each row. The measure you've written provides a table there instead. If you replace Filter() with Calculatetable(), it would work.

If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat

Re: What is the difference between these two uses of DATESYTD?

Anonymous — Fri, 22 May 2020 14:59:49 GMT

Well, you're missing the concept of logical conditions. Filters in CALCULATE/CALCULATETABLE are tables and logical conditions in FILTER. A table is not a logical condition.

Best
D