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 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Regards,
Rama U.