Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dataset record datastamp

Hi, my dataset has "CREATEDATETIME" column that contain a hierarchy data with  Year,Quarter,Month and Day.   In records you can also see hours, minutes and seconds but i can't use them because i d...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Besides solution above, you could create calculated columns directly

    year = YEAR([cretaedtime])

month = MONTH([cretaedtime])

day = DAY([cretaedtime])

weeknum = WEEKNUM([cretaedtime],2)

weekday = WEEKDAY([cretaedtime],2)

hour = HOUR([cretaedtime])

minute = MINUTE([cretaedtime])

seconds = SECOND([cretaedtime])

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Besides solution above, you could create calculated columns directly

year = YEAR([cretaedtime])

month = MONTH([cretaedtime])

day = DAY([cretaedtime])

weeknum = WEEKNUM([cretaedtime],2)

weekday = WEEKDAY([cretaedtime],2)

hour = HOUR([cretaedtime])

minute = MINUTE([cretaedtime])

seconds = SECOND([cretaedtime])

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

i created new colums like you, can i put these colums in CREATEDATETIME hierarchy?

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    As tested, i can't add "hours,,ect" columns in the hierarchy.

    Based on my experience, it doesn't matter when i use them together as a whole hierarchy.

    i can add them all in a matrix visual(add in Row field) or line/column/bar visual...(Add columns in X-axis)

    Then expand all down to one level or expand to next level.

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes, i did that.

       

      It's a bit confusing but it works, another question:

       

      By deafult users see the talbe with hierarchy data, then they drill down until the last data (seconds)

       

      Is it possibile let users choice how to see table?

      Like modeling the talbe in power bi desktop, but on power bi service because they can't modify real report.

       

      If users can'd do that we have to create a lot of page to let them see weekday x month, or weekday x hour etc...

       

      Don't know if you understood me

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi Anonymous 

        Which is "weekday x month, or weekday x hour" ?

        Do you mean drilling down to different level for each user? 

        Or show different measures?

        Based on my experience, we could create dynamic measures based on filter selection.

        Do you want this function?

         

        Please show more details for me to analyze.

         

        Best Regards
        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.