Values for previous and after year 2014

brijendraydv
Posts: 2
Joined: Fri May 05, 2017 7:40 pm

Values for previous and after year 2014

Postby brijendraydv » Fri May 05, 2017 11:59 pm

Hi Experts,

I have high hopes from you to solve this tricky powerbi automation requirement.
I have attached the screenshot of how i want the output at the end.
I want to keep year 2014 as reference .
So if any supplier with some part number in some plant as shown in image has no 2014 rate then take the immediate previous year rate as 2014 rate like PN- 222163-1 has only price in 2011 so it becomes price for 2014.
Now after getting the year14 price we go for 2015 which is not there again so 2014 price becomes 2015 price and likewise for 2016 and 2017.
Is it possible to use any calendar date function like with if condition using previous year calculation?

Once done i need some analytics on top of it like after this i need to know which supplier in same plant is having different prices.

Pls recommend your expertise.

Thanks,
Attachments
test.PNG
test.PNG (6.78 KiB) Viewed 526 times

brijendraydv
Posts: 2
Joined: Fri May 05, 2017 7:40 pm

Re: Values for previous and after year 2014

Postby brijendraydv » Sun May 07, 2017 6:10 am

Hi,

Here is the attached more detailed output i need.
Approeciate your help.
Attachments
scenario.xlsx
(45.36 KiB) Downloaded 29 times


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest