topic Re: DAX measure - fixed line between two dates in DAX Commands and Tips

DAX measure - fixed line between two dates

Filip_analyst — Wed, 11 Jan 2023 10:46:44 GMT

Hello everyone,

Is there any way to force DAX to calculate a constatnt line (1) between two dates? Chart below:

My current measure:

*Measure "Test1" is added to chart as line

Every time I play around with filter context (DIM_DATE) I receive a value 1 across all dates.
Thanks for any help 🙂

Re: DAX measure - fixed line between two dates

tamerj1 — Wed, 11 Jan 2023 13:03:02 GMT

HI Filip_analyst
Please try

Test2 = VAR date1 = MAX ( DIM_DATE[DATE] ) VAR date2 = DATE ( 2022, 01, 05 ) VAR date2 = DATE ( 2022, 06, 10 ) RETURN IF ( date1 >= date2 && date1 <= date3, 1 )

Re: DAX measure - fixed line between two dates

Filip_analyst — Wed, 11 Jan 2023 14:59:57 GMT

Works as expected, thank you tamerj1 ! 🙂