Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Today()

I have the following measure that occasionally throws an error I believe to be associated with the Today().     CurA = AverageX( CALCULATETABLE( 'FACT_PROD_CUM_VW', FACT_PROD_CUM_VW[Prod Date] ...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , When you subract days from date , like this DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-8)

     

    On the 8th on month this will error as date do not take 0 in day .

    Try like DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())) -8

     

    I have logged an issue sometime back on this.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , When you subract days from date , like this DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-8)

 

On the 8th on month this will error as date do not take 0 in day .

Try like DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())) -8

 

I have logged an issue sometime back on this.