Forum Discussion
DAX Intelligence formula not working YTD
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
Hi dpombal,
Instead showing 'trainings'[train_date] on your Table visual, use Calendario[Fecha], then all measures will work as expected. :smileyhappy:
Regards
2 Replies
- v-ljerr-msft
Microsoft Employee
Hi dpombal,
Instead showing 'trainings'[train_date] on your Table visual, use Calendario[Fecha], then all measures will work as expected. :smileyhappy:
Regards
- dpombal
Post Partisan
thanks beginner error!!