Forum Discussion
How to union data from multiple fact tables for different criteria
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!
3 Replies
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 👍
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 👍
