Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Zakaria_1980
Post Patron
Post Patron

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 NameFct dateDataPeriod
Project 101/06/202132821'P06
Project 101/07/202131321'P07
Project 101/08/202125221'P08
Project 101/09/20213421'P09
Project 201/06/2021021'P06
Project 201/07/20212321'P07
Project 201/08/202189021'P08
Project 201/09/20213421'P09
Project 301/06/20211221'P06
Project 301/07/20214521'P07
Project 301/08/202178921'P08
Project 301/09/20215021'P09

 

Actuals:

Project NameActual DatePeriod
Project 123/05/202121'P05
Project 112/06/202121'P06
Project 124/06/202121'P06
Project 101/07/202121'P07
Project 130/07/202121'P07
Project 126/07/202121'P07
Project 101/08/202121'P08
Project 201/06/202121'P06
Project 212/06/202121'P06
Project 224/06/202121'P06
Project 201/07/202121'P07
Project 203/08/202121'P08
Project 226/07/202121'P07
Project 201/08/202121'P08
Project 301/06/202121'P06
Project 312/06/202121'P06
Project 324/06/202121'P06
Project 301/07/202121'P07
Project 303/08/202121'P08
Project 326/07/202121'P07
Project 301/08/202121'P08
Project 302/07/202121'P07
Project 306/07/202121'P07

 

thanks

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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:

MFelix_0-1628261877918.png

 

Now creating a matrix visualization you can show the results:

 

MFelix_1-1628261909071.png

PBIX file attach.

 

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

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:

MFelix_0-1628261877918.png

 

Now creating a matrix visualization you can show the results:

 

MFelix_1-1628261909071.png

PBIX file attach.

 

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.