Forum Discussion

lakibalazs's avatar
lakibalazs
New Member
2 years ago
Solved

Pivot for SLA per week

Hi,   I have a data source with daily entries for individuals, whether they come to office or not on the given day. Each person is either billable or shadow, which can change with time. Besides da...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    lakibalazs

    you can try to create a column

     

    InOffice =
    VAR _count=countx(FILTER('Table','Table'[Week Number]=EARLIER('Table'[Week Number])&&'Table'[Shadow/Billable]=EARLIER('Table'[Shadow/Billable])&&'Table'[Name]=EARLIER('Table'[Name])&&'Table'[In office?]=true()),'Table'[Date])
    return if(_count>=2,"InOffice>=2","InOffice<=1")
     
     
    then create a matrix
     
    pls see the attachment below
     

     

lakibalazs's avatar
lakibalazs
New Member
2 years ago

Thank you! Perfect Solution!

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

you are welcome