DAX Intelligence formula not working YTD

[dpombal]

I am creating a quite simple report but Time Intelligence Formula do not work correctly, i have problems using time intelligence formula, however i am using a Calendar and Training sessions tables, both with date columns.

I have issues creating relationship

Relationships

I created a base measure

train_load = SUM(trainings[training_load_AU])

and then several formulas which do not work right now...

ytd = TOTALYTD(trainings[train_load];Calendario[Fecha])

last 30 days

train last 30 = CALCULATE([train_load];
                       DATESINPERIOD(Calendario[Fecha] ;MAX(Calendario[Fecha]);-30;DAY)
)

Here it is the pbix file  https://1drv.ms/u/s!Am7buNMZi-gwkC5b67MrMA0lxe9c

Regards

[v-ljerr-msft · Accepted solution]

Hi @dpombal,

Instead showing 'trainings'[train_date] on your Table visual, use Calendario[Fecha], then all measures will work as expected. 

 

Regards

[dpombal]

thanks beginner error!!