Forum Discussion
Quick Q: Datesbetween with If statement
I want to use DatesBetween in an IF Statement: =if(DatesBetween(Table[Date], Date(2021,03,09), Date(2021,03,21)),1,0) This won't work because DatesBetween Returns a table of the dates between...
Hi Anonymous ,
Try with this code..
Measure = IF ( AND ( Table[Date] >= DATE ( 2021, 03, 09 ), Table[Date] <= DATE ( 2021, 03, 21 ) ), 1, 0 )hi Anonymous try with below measure
Measure = IF (MAX('Table'[Date])>= DATE ( 2021, 03, 01 )&&MAX(Table[Date]) <= DATE ( 2021, 08, 31 ),1,0)
HI Anonymous,
You can also use the aggregate function to extract the current date and use the calendar function to generate the date range and use the 'in' operator to compare with them.
Measure = VAR currDate = MAX ( Table[Date] ) VAR dateRange = CALENDAR ( DATE ( 2021, 03, 09 ), DATE ( 2021, 03, 21 ) ) RETURN IF ( currDate IN dateRange, 1, 0 )Regards,
Xiaoxin Sheng
Hi Anonymous,
Did these suggestions suitable for your scenario? If that is the case, you can consider kudo or accept it to help others who face a similar scenario.
If they not helps, please share some more detailed information to help us clarify and test your situation.
Regards,
Xiaoxin Sheng