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

onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I thought this wouldn't work because directquery doesn't allow data type changes but did for this? I just need the dates for this so this is fine. In order to still have times in case I need them (eg for SLA) I made a duplicate column which I changed to Date.

    Some additional data type and format changes and now I have what I need