sql server - Getting a time out of datetime and use for comparison SSAS -


i have following issue:

i have orders table have [submit time] datetime column. need prepare tabular model 1 dimension timesofday (like 01:30:00, 21:00:00 etc.) can filter out orders on basis of [submit time] value.

how can create column extracting time [submit time] in tabular model?

outcome:

user opens powerview dashboard , can filter out orders based on timesofday


Comments