Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
Solved! Go to Solution.
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 )
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 )
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |