Forum Discussion
How to do time intelligence
Hi Friends,
I have a table which is Date table.
I have no idea how to join Date table to SO table.
I have explain below how to achieve the result I want.
Kindly help me.
Im struggling.
2 Replies
rainchong7401 , for the sync over you, need to create a new column
if(timevalue([SO_SyncedIn) >= time(18,0,0), datevalue([SO_SyncedIn) + 1, datevalue([SO_SyncedIn) )
for TI
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145sHi Amit,
What if I want it to become next day and always 8am.
How should I do it? instead of 12am?
