Forum Discussion

gnavia's avatar
gnavia
Icon for Helper I rankHelper I
6 years ago

Jerarchy Of Dates Granularity

Good morning to you all, I run into a problem, which I can't solve, I'm taking my first steps in POWER BI, so I have little experience and inity in the tool. With my company we are looking to de...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

gnavia ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

  • gnavia's avatar
    gnavia
    Icon for Helper I rankHelper I
    6 years ago

    @amitchandak Hello! and thank you for taking care of me. Of course, if I try to explain it as clearly as I can, I currently have data every 5 minutes in time:

    Tabla de datos.png

    But when I want to graph this data, grab an average of the day, for our business it is important monitoring according to the established every 5 minutes:

    What I'm looking for is that it recognizes the hours and minutes that has been loaded every day, and the granularity of the hierarchy is not only year, quarter, month and day, but also reach up to hour and minute. I generate a calendar table, and you don't recognize the minutes:

    CALENDARIO.png

    I hope it's somehow clearer.

    Thank you very much.

    • v-zhenbw-msft's avatar
      v-zhenbw-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi gnavia ,

       

      We can create a date table to meet your requirement.

       

      Date =
ADDCOLUMNS (
    DISTINCT ( 'Table'[Date] ),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "Quarter", QUARTER ( [Date] ),
    "Hour", HOUR ( [Date] ),
    "Minute", MINUTE ( [Date] ),
    "second", SECOND ( [Date] )
)

       

       

      If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

      BTW, pbix as attached.

       

      Best regards,

       

      Community Support Team _ zhenbw

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly