Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Date difference between date available in column and current date

Hi Experts, Please help me to find days between column date and today, i tried below code in custom column function but DateDiff is not recognised code.   =Datediff(Today(),AR[DATE],Day)
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi @Babumurugan,

    In PQ would be:

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

You can add a custom column and below DAX formula :

DateDiff = DATEDIFF( [DATE],TODAY() , DAY)