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
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