MAT Calculation from 2 Datasets

[Anonymous]

Hello everyone

I'm new into PowerBi and i love this place because i have been able to get some ideas.

But now im trying to do something that i have on my Excel spreadsheet but i want to do it in Power BI.

I'm building a MAT(Moving Annual Total).

In my Excel Spreadsheet i have the months with the years on top, but i want to add the my forecast into the months. My dataset is in 2 different Tabs one for the actuals and one for the forecasts and i want to have this in a single Matrix and then do a Line graph with this information to see the total amount per year.

What i'm trying to do is a formula in the Transform Data module, but i don't have the knowledge to do it.. on how to get the Forecast information into the actuals into a column , as i tried the sum , but it only give me full total...

any help is valuable! thx!

Example

2022                     2022                 2022               2022  

March(Actual)  April(Actual)     May (FCST)      Jun(FCST)

[v-kkf-msft]

Hi @Anonymous ,

Please create the following inter-table relationships and measure.

Measure = 
IF (
    MAX ( 'Calendar'[Date] ) >= TODAY (),
    SUM ( ForecastTable[Sales] ),
    SUM ( FactTable[Sales] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NickolajJessen]

The example you provided is an example of your desired outcome, right?

How is your data structured on the two tabs?
You might me searching for the transpose button, but it's hard to tell with no examples or pbix