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 - Fi...
Tips and Tricks
v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity 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