Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date formats in calculated table

Hi, so I've been working on a project trying to create a dashboard from a Freshservice export to help track tickets for our IT department. The export comes in as a giant table with closed date, created date, status, ID, etc... I've been struggling to properly chart the amount of tickets created, closed, and remain outstanding at the end of each day, and have been playing with a few different things. I decided to try a calculated table, here's what it looks like:

This looks like a really good first step, but I want the dates in created date and closed date to be grouped together, so that a 12/21 gets its own row, 12/22 the same, and so on. What's the easiest way to accomplish this? Would something like just going back to the original columns and changing the format for those dates do it? I am still learning PBI and DAX so any help would be greatly appreciated! Thanks!

  • Hi

     

    Yeah, you can go back to the source in power query and change the type to date:

     

     

    Also you could duplicate the column and use one part for date and the other for time should you need it later

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

     

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar

    Hi

     

    Yeah, you can go back to the source in power query and change the type to date:

     

     

    Also you could duplicate the column and use one part for date and the other for time should you need it later

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍