Forum Discussion
Solved
basic excel formula in power bi
I am trying to find a count of missing shifts. Assume 3 shifts/day, totaling 24 hours. basic excel formula below is 24 - billable hours, the next cell is /8 to get a count of how many shifts were mis...
Hi raicardi ,
to adjust the total try this measure
SUMX(
VALUES(Sheet1[Work Date]),
(24 - SUMX(Sheet1[Billable Hours])) /8
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ryan_mayu
Super User
Super Userwhat's the expected output? The 2 columns you showed in the sample data should be easy to get. The formula is the same as excel.
this is what is returned. The desired outcome is the same as the excel format outlined above. basically looking to see which days there were not 3 filled shifts to grab a total of how many were missing that day.