Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |