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
i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
4 years ago

amitchandak 
It worked when i have changed second argument as below

 

But still having issue with DATESINPERIOD function. Last argument which is interval is not accepting MONTH. Do you have any idea how can i solve it=

 

 

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..