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 

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

i want that users can choice how to see table.

 

User 1 want "hour" on Y axis and "seconds" on X axis.

User 2 want "month" on Y axis and "year" on X axis.

 

Is it possible to do that?

 

Thanks

v-juanli-msft wrote:

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.