Log In
Register
Home
May 2, 2021
Offline
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.
November 8, 2013
Offline
Hi Gli,
To create bins in DAX, you can use this formula in a new column of your Testenvironment table:
= SWITCH(
TRUE(),
Testenvironment[Aging]<=3, "1-3",
Testenvironment[Aging]<=14, "4 - 14",
Testenvironment[Aging]<=30, "15 - 30",
"Over 60"
)
1 Guest(s)
