Dynamically Pick current week data from 53 weeks

[Anonymous]

Hi All,

I have Data for each week starting from Jan to Dec 2019,i want to Pic dynamically the current week data among 53 weeks .

Based on the entries in the excel source file ,every week output will get changes.Here i do not have any date field in my source file

Please find the attached source and output screen shot..

Thanks,

Joshi

[parry2k]

@Anonymous does act_1, act_2.....so on, does these are week numbers?

If yes, does that mean at end of the year it will be act_53/52 depends on the year, correct?

and you want to pick the value from most recent week data is available in the sheet, correct?

[Anonymous]

Thanks for your Time.For all your questions yes is the aswer.

Those are week numbers and i want to pick most recent week data out of that

Thanks,

Joshi

[parry2k · Accepted solution]

@Anonymous  solution is attached, hope that is what you are looking for.

[Anonymous]

Hi Parry ,

Almost achieved desired output ,here my source file is looks as attached & how to create week numbers new column .

Thanks,

Joshi

[parry2k]

@Anonymous you should put your excel file as source  and  on unpivot step change the column name to "Business  Unit" and rest should work.