Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Floor function error for HH:MM timestamp

Hi,    I'm using SSAS tabular cube as data source and am not able to update the data source. I have a timestamp that is in HH:mm format, and need to get 30 min intervals from that. So placedtimes...
Need Help
  • raimon's avatar
    raimon
    3 years ago

    Hi Anonymous,

     

    Just change the datatype to time, you will get the value in time. 

     

    Floor PlacedTimeStamp = FLOOR(Intraday_PowerBI_Source[PlacedTimeStamp],"00:30") 

    Post changing the data type to time - 

     

raimon's avatar
raimon
Resolver II
3 years ago

Hi Anonymous,

 

Just change the datatype to time, you will get the value in time. 

 

Floor PlacedTimeStamp = FLOOR(Intraday_PowerBI_Source[PlacedTimeStamp],"00:30") 

Post changing the data type to time -