Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |