Forum Discussion

BI-ter's avatar
BI-ter
Regular Visitor
3 years ago

Matrix visualization - to combine 2 datasets

Hello eveyrone 

 

I am really new to the power Power BI - so I would be very thankful if you can advice on what is the optimal way to combine 2 datasets in 1 matrix visualisation. 

 

So my datasets are 2 separate queries / excel files:

• Actual (which is a detailed extract of transaction which is aggregated by the cost types) and

• Budget(which is not detailed at all); 

 

I need to combine actual + planned values to acheive full year forecast 

 

Let say last ended month is March. In the matrix I need to show 3 months of Actual + 9 months, like this (the third table is the

 

desired oucome) 

I loaded my datasets, created all of the necessery connections, etc. the question for me now is how to create this visualisation 

 

 

 

3 Replies

    • BI-ter's avatar
      BI-ter
      Regular Visitor

      Hello

       

      Many thanks for you reply 

       

      I was thking about DAX kind-of options as it is expectrd to be interactive in some ways