need help please

[Zakaria_1980]

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

[MFelix · Accepted solution]

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.