How to union data from multiple fact tables for different criteria

[Anonymous]

I will need a graph to demonstrate 4 criterias for differnt year and round, the mockup graph looks like below

The 4 criterias are: Revenue, Expense, EBITDA, and Margin, these fields are all available on different fact tables.

The rounds need to be Actual 2019, Actual 2020, Actual 2021, Actual 2022, Budget 2023, Forecast 2023, and Budget 2024.

The data is stored in different tables:

• FactActutal - has 2019 to 2022 actual numbers

• FactBudget - has 2023 & 2024 budgeted numbers
• FactForecast - has 2023 & 2024 forecast =numbers

Requesting help on how to union these required data field together in order to create the mockup graph. 

Really appreciate the help in advance!

[Anonymous]

Sorry! Forgot to mention, the data provided to me doesn't support Power Query, so have to use measures. Is there a way to achieve that?

[Idrissshatila]

Hello @Anonymous ,

Yes, you could use the union function chek this documentation https://learn.microsoft.com/en-us/dax/union-function-dax

check this video https://youtu.be/IPziqmQgJFw

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[Idrissshatila]

Hello @Anonymous ,

you need to use Append queries in Power query to union all of these three tables into one table.

check how to append queries https://learn.microsoft.com/en-us/power-query/append-queries

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡