cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MK_Process
Helper I
Helper I

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 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

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@MK_Process 

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
Super User III
Super User III

Hi @MK_Process 

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 

 

SU18_powerbi_badge

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors