Forum Discussion

sukraft's avatar
sukraft
Regular Visitor
8 years ago
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 time, they are just not in the dataset. I am looking for a way to report weekly who is missing time data.

 

I think I need to build a new table with calculated columns for each team member.  I tried this:

 

CALCULATE (SUM(Data[Hours]),Data[Resource Name] = "last,first",'Data'[Work Week Start] = 'Missing Time'[WeekStartDate])

 

but I get the error:  "The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression."

 

Has anyone done this before? 

 

Thanks in advance!

 

  • sukraft's avatar
    sukraft
    8 years ago

    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)
    )

1 Reply

  • sukraft's avatar
    sukraft
    Regular Visitor
    8 years ago

    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)
    )