Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

filter 4 date columns

 how to filter 4 date column in power bi using measure r columns

Filter = App Date = current month OR
- Filter = Approval Date = currrent month OR
- Filter = Funding Date = currrent month OR
- Filter = UW Submit Date = currrent month
- Filter = Lien Position must be second

 

Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    MAYBE explaining better what you want to do would help, but anyway you can't have filters in OR. Filters are always in AND.

    What you can do is to have a secondary calculated column where you calculate the month based on your ORs and use that as a filter.

     

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    I am confused about your requirement, but hope this measure can help:

    Measure = IF(MAX('Table'[App Date])=TODAY()||MAX('Table'[Approval Date])=TODAY()||MAX('Table'[Funding Date])=TODAY()||MAX('Table'[UW Submit Date])=TODAY(),1,0)

    Please give more info about your sample data and expected result as screenshots.

    Remember to remove any sensitive data.

    Thanks!

     

    Best Regards,

    Giotto Zhi