Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.