Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Aggregate Hourly graph

Hi,   I've been trying to create the below graph in PowerBI:   It's a month's worth of data aggregated per time bracket.   My data column in BI has both date and time, however I can't jus...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    it's difficult to help you without seeing full data model but try something like that

    TIME BRACKET = MROUND(FORMAT(RP566[CREATE_DATE_TIME],"hh:mm:ss"),"0:30")

    do not hesitate to give a kudo to useful posts and mark solutions as solution

     

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

it's difficult to help you without seeing full data model but try something like that

TIME BRACKET = MROUND(FORMAT(RP566[CREATE_DATE_TIME],"hh:mm:ss"),"0:30")

do not hesitate to give a kudo to useful posts and mark solutions as solution