DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD - DAX Guide

Great sir. Hope to learn more about DAX measures and Practical examples.

Hi. Great. How can we change the ytd start and end date. As default it takes calendar quarters. We need to change it for fiscal calendar like 1st feb as start.

Very well explained.

how amazon are these guys

Ciao,
I'm curious about the CALCULATETABLE when the whole is already inside CALCULATE,
I've had a look in ' THE BOOK', and can't find an explanation, if it's very complex please just say so. Richard.

Hello, I want to create a comparison of current year to date against previous years.
I've used DATEADD and it works.
-However, I need one of the previous years to be calendar year 2019.
-Using minus 3 worked for year 2022. Now that it is year 2023 I will have to update the formula to minus 4.
How can I filter for year 2019 without having to update my formula annually?
See formula below:

Legend:
Pax = passengers (I'm analyzing commercial aviation data)
'_Calendar'[Date] = date table

Pax YTD 2019 =
IF (
ISBLANK ( [Pax] ),
BLANK (),
TOTALYTD ( [Pax],
DATEADD ( '_Calendar'[Date],
-3, YEAR ) )
)

Thx in advance for you help.

Why date[date] is translated into CALCULATETABLE ( DISTINCT ( <Dates> ) ? I can't find an explanation in the book or on SQLBI? Could someone explain it?

Muy buena explicación muchas gracias me ayudó en mi reporte

Finished watching