Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!