Forum Discussion
Solved
Identify people that have missing weeks from time reporting
Hi Everyone, PowerBi novice here... We are trying to transition from multiple data sources into PowerBi. Every week I get a dump of time keeping data for our team. If someone doesn't report in...
Incse anyone else needs it, I was able to work through the issue...
This worked and returns the data that I need...
SSO Hours = Summarize(Data, Data[Work Week Start],
"Mike", IF(CALCULATE(SUM(Data[Hours]), Data[Resource Name] = "XXX, Michael") > 0, CALCULATE(SUM(Data[Hours]), Data[Resource Name] = "XXX, Michael"), 0)
)
Incse anyone else needs it, I was able to work through the issue...
This worked and returns the data that I need...
SSO Hours = Summarize(Data, Data[Work Week Start],
"Mike", IF(CALCULATE(SUM(Data[Hours]), Data[Resource Name] = "XXX, Michael") > 0, CALCULATE(SUM(Data[Hours]), Data[Resource Name] = "XXX, Michael"), 0)
)