Want to see Actual VS Plan Info together?

[Anmolgan]

Hi, I have two queries one contains my plan information and another contains actual information, problem is I have one key column that is basically making many to many relationship in the report, now I want to see both plan and actual infromation in one visual is there any best way to do this, for example check the screenshot below, I have Bihar sales for April as 47642 (Plan) and Bihar Sales for April as 52441 (Actual), is there any recommendation of seeing the visual together? 

I tried merging them but it some how not gives me correct result, and I need this to be done in such a way so that I can see the results correct as per Month, and Sales office. Please let me know if there is a need of my powerbi file and I will try to provide.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.  Since i may need to carry out a transformation in the Query Editor, I will also need the source Excel files for all Tables.

[amitchandak]

Create common dimensions Month/date. If one at month level and another at date level, use Month start to join with date table for a table at the Month level.

The sales office is another common dimension

Sales Office = distinct( Union(all(Actual[Sales Office]), All(Target[Sales Office])))

Join with both the tables