Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
how do I get rolling days:
Example today is 16.03.2022
- in the evaluation all values should be filtered by YTD
- 16.03.2022
- 16.03.2021
- 16.03.2020
Solved! Go to Solution.
Hi, @DagdasAlbag ;
Try to create a column.
rolling = IF(MONTH([Date])<MONTH(TODAY()),1,IF(MONTH([Date])=MONTH(TODAY())&&DAY([Date])<=DAY(TODAY()),1,0))
The final output is shown below:
Or create a measure:
rolling days = DATEDIFF(DATE(YEAR(TODAY()),1,1),TODAY(),DAY)
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @DagdasAlbag ;
Try to create a column.
rolling = IF(MONTH([Date])<MONTH(TODAY()),1,IF(MONTH([Date])=MONTH(TODAY())&&DAY([Date])<=DAY(TODAY()),1,0))
The final output is shown below:
Or create a measure:
rolling days = DATEDIFF(DATE(YEAR(TODAY()),1,1),TODAY(),DAY)
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @DagdasAlbag,
I think you dont need DATE(TODAY()), TODAY() already gives you date.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |