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 gave the desired outcome, but how do i fix the total to sum the column??
- mangaus1111
Solution Sage
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.