Filter Data by Current Month and the Next 3 Months

[harakuruku]

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? 

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.  Also, show the expected result there.

[TomMartens]

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

• here is the official documentation: https://msdn.microsoft.com/en-us/query-bi/dax/userelationship-function-dax
• and here a great article: https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

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