Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So I have 3 different tables. Pipeline, Invoiced & Backorder. I created a Date table and created a relationship with Pipeline entity. To give more details in relationship here's how they are connected:
Backorder to Accounts
Accounts to Pipeline
Pipeline to Invoice
Pipeline to Custom Date Table
I need to filter my data to show current month related to the Account, but the thing is they all have different date source. What I'm saying is when I filter it by the Date from custom Date table, everything is filtered by the date from Pipeline because that's what I used to connect them all. Any advice on how to connect the custom Date table to all the dates in Backorder and Invoice as well?
Hi,
Share the link from where i can download your PBI file. Also, show the expected result there.
Hey,
you could creeat non-active relationships between your date table with your tables Backorder and Invoice
The non-active relationships then can be used using the DAX function USERELATIONSHIP
Hopefully this gives you some ideads.
You may also consider, to provide some sample data, upload the Power BI file to onedrive or dropbox and share the link.
Regards
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |