Help with Time Measurement with Day Break

[Anonymous]

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 in BI and select the date of 01/01/2021, system will show us the production from 12:00 AM 01/01/2021 to 11:59 PM 01/01/2021.

Is there any way to formulate or calculate hat when we select date os 01/01/2021, system calculates from 8:30 AM 01/01/2021 to 8:29 AM 02/01/2021?

Faisal

[Anonymous]

@Anonymous 

Also you might need to create a measure to filter the production time, make it between the start time and endtime.

Measure = CALCULATE(MAX([Production]),FILTER('Table',[DateTime]>=[Starttime]&&[DateTime]<=[Endtime]))

Not sure how did you record your data. It would be more clear if you can share a sample and expected output in table.

Regards

Paul

[AlB]

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