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...
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
Super User
Super UserHello 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 👍