Forum Discussion

Filip_analyst's avatar
Filip_analyst
Frequent Visitor
3 years ago
Solved

DAX measure - fixed line between two dates

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 ...
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    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 )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

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 )
  • Filip_analyst's avatar
    Filip_analyst
    Frequent Visitor
    3 years ago

    Works as expected, thank you tamerj1  ! 🙂