Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculating Age [Direct Query]

I'm trying to calculate the age of events but using direct query is very different than the reports I've done from spreadsheets in the past. Can someone help me please?

 

I have Task_Created_Date which shows the date format as xx/xx/xxxx

 

 

Need Help

5 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    8 years ago

    Hi Anonymous,

     

    Are you referring to Power Query instead of Direct Query? 

    Calculating age can be achieved by using creating a calculated column in DAX.

    DATEDIFF( start date, end date, interval) 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi there,

      no, specifically direct query. I'm pulling data from a live database.

       

       

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        8 years ago

        Have you tried creating a custom column that subtracts the start from end date?