Dynamic Last 4 Weeks when selected fiscal week in Slicer(i.e-selected value + Last 3 Weeks)

[Anonymous]

Dear All,

How to create Dynamic Last N Weeks based on Fiscal_Week number, when Fiscal Week value in slicer is selected, in matrix visual or any pivot visual, Selected week + last 3 weeks should appear  

Below 

I have created Matrix Visual which contains details below -

On Rows - Product-L1

On Colums - Fiscal Week

Values  - Efficiency

Below Screenshot

Then i created Matrix Visual using these colums, screensot below -

Matrix Visual (Fiscal Weeks @ Column Level)

Above image i have selected 202033, 32, 31, 30 manually

Outcome - Now if i select 202033 automatically visual should show 202033, 20232, 202031, 202030

DataSet

[Greg_Deckler]

@Anonymous - Replying from your PM. First, some sample data in a format that can be copied would be very helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

That being said, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

You should be able to figure out the last 4 weeks and only return values for those weeks, which should automatically exclude all of the other weeks in your matrix visual.

[Anonymous]

@Greg_Deckler  - as you said i want in this way

"You should be able to figure out the last 4 weeks and only return values for those weeks, which should automatically exclude all of the other weeks in your matrix visual."

Files below- 

Sample Data and pbxi file

[amitchandak]

Try something like this

Last 4 WEEK
var _max_week = max(Fiscal Week)
var _date = calculate(max(date),all([Fiscal Week]),[Fiscal Week]=_max_week)
var _min_week = calculate(min(Fiscal Week),[date]= datediff(date,-28,day)

return
calculate(sum(x),all([Fiscal Week]), [Fiscal Week] >=_min_week and [Fiscal Week] <=_max_week)

[Anonymous]

Getting error amit - screenshot below

[amitchandak]

in third one in place of _date_ use vwReportinData[created_on]

[Anonymous]

i have only createddate column as below snap,

As i dont have created_one column, can you help me understand about this line  "in third one in place of _date_ use vwReportinData[created_on]"

also can you please re-frame query and send it

[amitchandak]

Oh, you have created_date, copy from image in

third one in place of _date_ use vwReportinData[created_date].(Third in the sequence)

In case it does not work, paste formula, not image.