Forum Discussion

dpombal's avatar
dpombal
Icon for Post Partisan rankPost Partisan
8 years ago
Solved

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's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi dpombal,

     

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

     

     

     

    Regards