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.

Anonymous's avatar
Anonymous
Not applicable
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.