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 hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
Regards,
Rama U.