cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshi Frequent Visitor
Frequent Visitor

Dynamically Pick current week data from 53 weeks

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..

 

Source&Output.png

 

 

Thanks,

Joshi

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dynamically Pick current week data from 53 weeks

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

 

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




5 REPLIES 5
Super User
Super User

Re: Dynamically Pick current week data from 53 weeks

@joshi 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?





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




joshi Frequent Visitor
Frequent Visitor

Re: Dynamically Pick current week data from 53 weeks

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

Super User
Super User

Re: Dynamically Pick current week data from 53 weeks

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

 

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




joshi Frequent Visitor
Frequent Visitor

Re: Dynamically Pick current week data from 53 weeks

Hi Parry ,

 

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

 

 

 

Thanks,

JoshiWeek numbers.png

Super User
Super User

Re: Dynamically Pick current week data from 53 weeks

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

 

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.