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.
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 the range given.
Is there a work around/way to make this work?
I just want to mark the dates 03/09-03/21/21 in my table with a 1.. all other dates with a 0.
Solved! Go to Solution.
Hi @kressb ,
Try with this code..
Measure =
IF (
AND ( Table[Date] >= DATE ( 2021, 03, 09 ), Table[Date] <= DATE ( 2021, 03, 21 ) ),
1,
0
)
hi @kressb try with below measure
Measure = IF (MAX('Table'[Date])>= DATE ( 2021, 03, 01 )&&MAX(Table[Date]) <= DATE ( 2021, 08, 31 ),1,0)
HI @kressb,
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 @kressb,
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
HI @kressb,
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 @kressb try with below measure
Measure = IF (MAX('Table'[Date])>= DATE ( 2021, 03, 01 )&&MAX(Table[Date]) <= DATE ( 2021, 08, 31 ),1,0)
Hi @kressb ,
Try with this code..
Measure =
IF (
AND ( Table[Date] >= DATE ( 2021, 03, 09 ), Table[Date] <= DATE ( 2021, 03, 21 ) ),
1,
0
)
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |