Forum Discussion
joshua1990
Post Prodigy
Post ProdigyFilter 1 table based on another table based on Article Selectio
Hi experts!
I have a report that shows 2 tables.
The first one display our sales on Article level for the selected week. The selection here happens based on a filter slicer.
Then I have a secon...
joshua1990Post Prodigy
Post ProdigyMaybe a disconnected calendar table for the second table?
amitchandak
Super User
Super Userjoshua1990 , yes disconnected date table with week rank
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Week Rank])
var _min = _max -4 //or use 5
return
alculate( sum(Table[Value]), filter('Date', 'Date'[Week Rank] >=_min && 'Date'[Week Rank] <=_max))
where for week rank create a column using YYYYWW or week start date
Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format
in both date tables