Forum Discussion

joshrumbawa's avatar
joshrumbawa
Frequent Visitor
2 years ago
Solved

Filter 2 dates column in 1 table

Hello PBI Experts, I have a requirements to filter the fact table based from Date Dim table. I have 2 dates column to consider the Application Date and the Approved date. In my datamodel, the d...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi joshrumbawa 

     

    First of all, thanks to lbendlin and Wilson_ for your timely reply.

     

    Here is the test I did.

     

    My sample:

     

     

    There is no relationship between the two tables.

     

    Create a measure:

    Measure = IF(MAX([Application Date]) >= MIN('Date'[Date]) && MAX([Application Date]) <= MAX('Date'[Date]) || MAX([Approved Date ]) >= MIN('Date'[Date]) && MAX([Approved Date ]) <= MAX('Date'[Date]), 1, 0)

     

    Put the measure into the filter so that the visual only shows data where the measure is equal to 1.

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Super User
2 years ago

With the standard data model you have two options

 

- AND - filter on both columns, filters will overlay

- EITHER OR - employing USERELATIONSHIP you can switch the filter between the columns

 

What you want is OR - that is not supported in the default data model.  It requires disconnected tables to feed your slicers/filters, and measures as visual filters to apply the selections to the data model's fact table.