Forum Discussion
Help with Time Measurement with Day Break
Hi In our Daily report we calculate our production from the production which has happened from 8:30 AM 01/01/2021 to 8:29 AM 02/01/2021 on the next Day as the production figures. But when we make it...
Hi Anonymous
You could create an additional calculated column in your fact table that assigns the date as you want it shown, i.e. if datetime in that row is 01/01/2021 8:00 AM the result for that column will be 12/31/2021 but for 01/01/2021 8:30 AM it will be 01/01/2021 and so forth.
Then create a relationship between you date table and that newly created column
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers