Forum Discussion

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
4 years ago

Date Table and Time Intelligence Functions not working anymore

Hello I dont know the reason but i had properly working date table function and time intelligence functions before, but not working anymore. I dont know if its related with latest updates.   A...
Date Table
datesinperiod
Time Intelligence
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

i_kafali , First Argument is wrong

 

keep it simple like. Not sure why they are taking year of date , that is not even a text

 

date(2020,01,01)

 

 

Also, try this as a measure , assuming [Volume (Ton)] is  measures 

Rolling 3 = CALCULATE([Volume (Ton)],DATESINPERIOD('Date'[Date],MAX('Date'[Date ]),-3,MONTH))

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
4 years ago

amitchandak i solved the problem

I had to make it like Date(2020, 1, 1) instead of  Date(2020,1,1)

 

I dont know why it needs one space between arguments. also solved the DATESINPERIOD formule with leaving one space between last arguments. Interesting..