Forum Discussion
How to filter Next "X" weeks data dynamically
- 1 year ago
Instead of table , matrix visual could be better for you use case
where u can add project names in rows section while in date table you can create new column:
Week = WEEKNUM([Date],1)
use this Week in column section
Now create a Numeric field parameter(in Modelling tab) and name it say week_count
then create a measure:
(im assuming your each release is a different record in table, if not change accordingly)
project_count =
var curr_week=WEEKNUM(Today(),1)
return
calculate(countrows(table[column]),filter(Date table,[Week]>curr_week && [Week]<curr_week+3))
now use this measure in the values section
if this helps you in any way, please accept it as solution
Hi ajitsahoo8338 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Regards,
Rama U.