Getting a time out of datetime and use for comparison SSAS

Asked Aug 01 '16 at 14:32

Active Aug 01 '16 at 14:32

Viewed 41 times

I have the following issue:

I have Orders table that have [Submit Time] Datetime column. I need to prepare a tabular model where one dimension will be just TimesOfDay (like 01:30:00, 21:00:00 etc.) so I can filter out orders on the basis of the [Submit Time] value.

How can I create another column extracting just the time from [Submit Time] in Tabular model?

Outcome:

User opens a Powerview dashboard and can filter out orders based on TimesOfDay

asked Aug 01 '16 at 14:32

JS_Diver

CAST([Submit Time] AS TIME) – Chris Pickford Aug 01 '16 at 14:35
I cant use that in VS in tabular model – JS_Diver Aug 01 '16 at 14:45
Restructure your model. – Chris Pickford Aug 01 '16 at 14:46
I am just thinking now that a simple FORMATfunction in DAX might do the job actually.. – JS_Diver Aug 01 '16 at 14:51
I'd rather go with adding calculated column and passing its value into the model instead of actual date/time. – Slava Murygin Aug 01 '16 at 20:36

Getting a time out of datetime and use for comparison SSAS

0 Answers0