Forum Discussion
IF - SUM - Utilization Table
Hi Everyone, In company, we are using Timesheet Application. We are taking their datas from sharepoint. So each week new datas are coming from personnal. Here I have a Calculated Table. In this t...
Stachu
Community Champion
Community Championare you OK with changing your data model? This problem is very easy to solve if instead of creating a Table you create a measure and use Matrix visual to display it as a table. It would require the RateListBU table to look like this (you could unpivot it in Power Query)
| Personal | Department | Job | Week | Value |
| A | Research | Engineer | Week 1 | 0.99 |
| A | Research | Engineer | Week 2 | 0.45 |
| A | Research | Engineer | Week 3 | 0.38 |
| A | Research | Engineer | Week 4 | 0.44 |
| A | Research | Engineer | Week 5 | 0.22 |
| A | Research | Engineer | Week 53 |