DAX shits minutes calculate - please read all -- 2
€2-6 EUR/小时
I have a statement sheet where there are for each machine start time and end time of the event.
I created two columns (for only hour) called Start and End
In PBI I created a Shift column to specify if the shift is Morning / Afternoon / Night.
However, there are rows where the statement starts in the morning and ends in the afternoon (e.g. row 159 - start 1:56 pm - end 2:15:59 pm).
I need to calculate the afternoon accrual minutes and the morning accrual minutes.
The shifts are:
morning 06.00 - 13.59
afternoon 14.00 - 21.59
night 22.00 - 05.59
The purpose is to figure out, for each type (code on type column) the minutes per shift morning, afternoon, night for each day. The ideal result is a table report with a day column, shift column, type column, minute column that should represent the sum of minutes for the type (e.g., type 1 - morning shift - sum of minutes of type 1 for that day for morning shift).
I provide xls file. I need the final powerbi file
项目ID： #37773420
关于项目
授予：
As a dedicated and experienced Power BI professional, I understand your project requirements inside out. My proficiency in handling complex data analytic tasks makes me perfectly poised to tackle your DAX calculations 更多
