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. ...
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=145s
Hi Amit,
What if I want it to become next day and always 8am.
How should I do it? instead of 12am?
