May 2, 2021
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.
November 8, 2013