How to create a matrix that compares Actual and Forecast over several dates ?

[VKdM]

Hello, 

I would like to create a matrix comparing the Actuals and Forecast to see the evolution of the accuracy of the Forecast.

I'm not sure how to get there, if at all possible?
My hypothesis would be to create date tables for Actuals and Forecasts to have two different date measurements in the matrix, what do you think?
The result would look loke this :

Currently, the data set provided is a PowerBi data set with dozens of tables as :
Actual            Others tables
DateKey  *:1 others keys
ActivityKey *:1 others keys
Forecast          Others tables
Activity Key *:1 others keys 
DateKey  *:1 others keys
Date               Others tables
DateKey 1:*  others keys 

I'd like to produce this report based on the powerbi dataset, to avoid having to extract data on a monthly basis and upload excel files.

Thank you for the help

[Vinod_P]

A matrix can help getting this but should ensure relationships are properly mapped or another option is to you can use merge or append queries to consolidate into a single sheet and map rows ,columns & values. For colors you can use cell elements --> font color. Sample data would be great to understand better . 

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[amitchandak]

@VKdM , I tried something similar in past
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Anal...

Power BI Cohort Analysis, Customer Retention %- https://youtu.be/qY1SDF1cwsg