Power Pivot Lookup Value Calculation - Not exact match result (Stack Chart Final Product)|Power Pivot|Excel Forum|My Online Training Hub

Hi All,

Good day! I would like to seek help in regards to my ongoing problem. I am rookie with power pivot and dax and as I am starting to understand the logic syntax, I still faces challenges. 

In the attached file. Basically the final product that I want to achieve is to have a chart transformation based on the calculation.

Step 1 was me doing it from scratch a simple vlookup up of Aging column to "Bases of Value Age". Column E and F in the result sheet is the final product. And I had to combine it in one column which is the G.

Step 2 until i discover on how to do IF and Vlookup function at the same time.

Step 3 is that I am trying to integrate the data by using the power pivot. I saw some helpful videos in the past with create new measure so that a new column will be added in the in the pivot table modeling.

As you can see from the snip, I have attempted to combine the step 2 syntax that I know to the pivot however it appears that I have no luck to achieve it. 

What I want is for a new column to show with the result based on the aging. I am not looking for an exact match but a closer range from the aging number bracket based on the categories listed of the clothes.

Step 4 the end result would be me being able to provide a stack chart according to name. If I can do the step 4 then I cross the step 1 - 3 as I am working on a big data. 

Apologies if I have to ask this in excel format as Power BI is not commonly use. 🙁

I hope that you can help me with my problem.