Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply

If condition to filter by date

Hello,

I want to filter the column Magasin in a slicer visual when the selected date is between range of date  with this:

if(max_<=date_max && max_>=date_min ,1,0)
The result is 0 while it's should be 1 for the top 3 of the year because it's take the lastdate of the year.
ConditionYearMagasin
02021ST MARC

 

ConditionYearMonthMagasin
1202101ST MARC
1202102ST MARC
1202103ST MARC
0202104ST MARC

 

When i apply the filter at 1 on the slicer Magasin and i'm using the slicer year my value is filtered and i want even if i have only 3 months the result has to be 1 for the year .

To be clearer, if there is at least one month in which the condition is equal to 1, the condition must be equal to 1 for the whole year.

Thank you for your help

1 REPLY 1
lbendlin
Super User
Super User

Use MAXX  over the monthly results.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.