cancel
Showing results for
Did you mean: Helper I

## chart Hours

1º Have to calculate a difference between Final Hour and Start hour, per day.

``````_01Total HH =
CALCULATE(
SUMX('hh tsv','hh tsv'[Final Time]-'hh tsv'[Star Time]),
'hh tsv'[Action] in{"Production"},'hh tsv'[product] in {"P13"}
)``````

2ºAfeter this I will use a matrix to organize the result

So i have to adapt the measure to show right total hour ``Total HH = INT('hh tsv'[_01Total HH])*24+FORMAT('hh tsv'[_01Total HH],"hh")&":"&FORMAT('hh tsv'[_01Total HH],"nn")``

3º after this I calculate the extra hour, to saturday's I have to subtract 04:00hrs the Total HH to other days just 08:00 hrs

``_02 Horas extra = [_01Total HH] - IF( WEEKDAY(MAX('hh tsv'[DATE]),1) = 7 ,TIME(4,0,0), TIME(8,0,0))``

to right formt the total extra hour I use

``Total Extra hour = SUMX(VALUES('hh tsv'[DATE]),[_02 Horas extra])``

4º I have to divide the extra hour per total hour, to analyse em porcentagem how many extra hours I did in relation total hh and plot it in a chart and plot a char the total hour per day . But How I'm use measure until here I dont know how to do it.

2 REPLIES 2 Super User IV

@Estyfodense

Check the attached file for the measures and the added columns. It is converted to minutes for the Extra Hours.
You have started another thread on the same topic please close both by accepting a reply if it works for you.

https://1drv.ms/u/s!AmoScH5srsIYgYUgfpeX9ZLdUic9mQ?e=83Ye7C ________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

Proud to be a Super User! Helper I

A oppen a another to explain better, so The format of the time is wrong.
Its almost like that.  Estoy aprendiendo a usar la plataforma https://onedrive.live.com/?authkey=%21ABrRLkG1lSx7CCA&cid=59DCB3D8412CF0F3&id=59DCB3D8412CF0F3%21230...   