Beacause I can’t find any video’s and content about TIME, I have the following question. I would like to calculate nr of total orders in a “day” with a timeframe of: 21.00 - 20.59 (24 hours). So the days have a overlapping character. The image underneath will explain my question further.
I got one solution, might not be an ideal one:
1.First, create a column in the Orders table. As this is a fact table, it is not recommended when rows reach certain amounts.
Calibrated Order Date = IF(and(Orders[Order Date]=Orders[Order Date], Orders[Order Time]>=TIMEVALUE(“21:00”)), Orders[Order Date]+1,Orders[Order Date])
Hi @NickvanDijk, did the response provided by @Kumail help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!
Hi @NickvanDijk, we’ve noticed that no response has been received from you since the 21st of May. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.