Forum Discussion
Time slots/stamp analyses
- 5 years ago
PasiNiinikoski , Separate out time and date
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))DateTime.Date([datetime])
Time = [datetime].Time
or
Time = Time(hour([datetime]),minute([datetime]),second([datetime]))Join time with Time table and have 30 Min bucket there and date with date table
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Thanx! I have read your both links and watched the videos in them and believe this is just what I needed. Will work on it soon and test different visuals also.