This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Getting the data from multiple tables with no relation
1. emp Reference data (Fact Table Where all the details are present)
2. Calculated Table (where everything needed for the table is added)
3. because I dont have All th OU present in either of the table I have created union table of all
What I need
Here in this matrix I am using Month of calculated table
ou from union of ous from other fact tables- As planned employ have different ou which may or may not be in emp reference table for all months
It would be really helpful as I am stuck for 2 weeks now
@PBCommunity @Greg_Deckler
@Employee It's extremely difficult to understand what you are trying to do here. Is there any way you can post sample data as text so that this can be mocked up?
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 36 | |
| 29 | |
| 29 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 69 | |
| 39 | |
| 33 | |
| 24 | |
| 23 |