Page 1 of 1

Values for previous and after year 2014

Posted: Fri May 05, 2017 11:59 pm
by brijendraydv
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.


Re: Values for previous and after year 2014

Posted: Sun May 07, 2017 6:10 am
by brijendraydv

Here is the attached more detailed output i need.
Approeciate your help.