filter 4 date columns

[Anonymous]

 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

[v-gizhi-msft]

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

[Anonymous]

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.