Forum Discussion
need help please
Hi,
i've two sheets, one called forecast & the other one called Actuals.
i've tried to get one table showing me in rows project names , in columns periods and in values Forecast and actuals.
the forecats should be the sum of data (forecasted) per period and per project
the actuals should be the count of actual date (actual) per period and per project.
below the 2 tbls. can someone send me pbi report so i can understand where is excately my error.
Forecast:
| Project Name | Fct date | Data | Period |
| Project 1 | 01/06/2021 | 328 | 21'P06 |
| Project 1 | 01/07/2021 | 313 | 21'P07 |
| Project 1 | 01/08/2021 | 252 | 21'P08 |
| Project 1 | 01/09/2021 | 34 | 21'P09 |
| Project 2 | 01/06/2021 | 0 | 21'P06 |
| Project 2 | 01/07/2021 | 23 | 21'P07 |
| Project 2 | 01/08/2021 | 890 | 21'P08 |
| Project 2 | 01/09/2021 | 34 | 21'P09 |
| Project 3 | 01/06/2021 | 12 | 21'P06 |
| Project 3 | 01/07/2021 | 45 | 21'P07 |
| Project 3 | 01/08/2021 | 789 | 21'P08 |
| Project 3 | 01/09/2021 | 50 | 21'P09 |
Actuals:
| Project Name | Actual Date | Period |
| Project 1 | 23/05/2021 | 21'P05 |
| Project 1 | 12/06/2021 | 21'P06 |
| Project 1 | 24/06/2021 | 21'P06 |
| Project 1 | 01/07/2021 | 21'P07 |
| Project 1 | 30/07/2021 | 21'P07 |
| Project 1 | 26/07/2021 | 21'P07 |
| Project 1 | 01/08/2021 | 21'P08 |
| Project 2 | 01/06/2021 | 21'P06 |
| Project 2 | 12/06/2021 | 21'P06 |
| Project 2 | 24/06/2021 | 21'P06 |
| Project 2 | 01/07/2021 | 21'P07 |
| Project 2 | 03/08/2021 | 21'P08 |
| Project 2 | 26/07/2021 | 21'P07 |
| Project 2 | 01/08/2021 | 21'P08 |
| Project 3 | 01/06/2021 | 21'P06 |
| Project 3 | 12/06/2021 | 21'P06 |
| Project 3 | 24/06/2021 | 21'P06 |
| Project 3 | 01/07/2021 | 21'P07 |
| Project 3 | 03/08/2021 | 21'P08 |
| Project 3 | 26/07/2021 | 21'P07 |
| Project 3 | 01/08/2021 | 21'P08 |
| Project 3 | 02/07/2021 | 21'P07 |
| Project 3 | 06/07/2021 | 21'P07 |
thanks
Hi Zakaria_1980 ,
You need to create two additional tables:
Projects
Periods
Then make a one-to-many relationship with the other two tables will get something similar to this:
Now creating a matrix visualization you can show the results:
PBIX file attach.
1 Reply
Hi Zakaria_1980 ,
You need to create two additional tables:
Projects
Periods
Then make a one-to-many relationship with the other two tables will get something similar to this:
Now creating a matrix visualization you can show the results:
PBIX file attach.