Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cannot match date to date table

I'm trying to make reports from our ticketing system. Most require displaying ticket count per month with some added info or filtering. I created a calendarauto table with relation to the ticket tabl...
Need Help
  • onurbmiguel_'s avatar
    onurbmiguel_
    4 years ago

    Hello AlmostDev

    Did you need to use the hours? 

    If not, go to power query and change to date the two columns. 

     

     

    close and applly 

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
    Best Regards
    BC

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

Anonymous , Create a new column

 

Create_date = Datevalue([Craeted_time])

 

join this with Date table

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I would prefer this but I get "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression." when using the Datevalue.