Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
108 | |
88 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |