Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have two calculated Columns which I created in the Data view from other Columns. The Calculated Columns are [Number of Days] and [Action]
Number of Days | Action | Result |
4 | 2 | Green |
6 | 2 | Yellow |
8 | 2 | Red |
15 | 3 | Blue |
16 | 4 | Orange |
I want to Have another Calculated Column , [Result]in the Data based upon following conditions;
If [Number of Days]<=5 and Action<=2 THEN Green
ELSE IF [Number of Days]>5 and [Number of Days]<8 and Action<=2 THEN Yellow
ELSE IF [Number of Days]>=8 and Action<=2 THEN Red
ELSE IF [Number of Days]<=15 and Action<=3 THEN BLUE
ELSE IF [Number of Days]>15 and Action>3 THEN Orange
ELSE Violet
END
Please Help in writing the above to get [Result] Column values
Thanks
Deepak
Solved! Go to Solution.
The DAX is like
Column = SWITCH ( TRUE (), yourTable[Number of Days] < 5 && yourTable[Action] <= 2, "Green", yourTable[Number of Days] < 8 && yourTable[Action] <= 2, "Yellow", yourTable[Number of Days] >= 8 && yourTable[Action] <= 2, "Red", yourTable[Number of Days] <= 15 && yourTable[Action] <= 3, "blue", yourTable[Number of Days] >= 15 && yourTable[Action] > 3, "Orange", "Violet" )
You can use IF and SWITCH function in DAX to do this. You can either use nested IFs (which should map pretty easily for your sample condition) or SWITCH with first parameter as TRUE and each condition representing an arbitrary condition expression.
Hi SRINIVT,
I am Totally new to Power BI and I am stuck on this. Can you please do one more favour and write the Formula. I had tried earlier but could not do, so I posted here.
Thanks
Deepak
The DAX is like
Column = SWITCH ( TRUE (), yourTable[Number of Days] < 5 && yourTable[Action] <= 2, "Green", yourTable[Number of Days] < 8 && yourTable[Action] <= 2, "Yellow", yourTable[Number of Days] >= 8 && yourTable[Action] <= 2, "Red", yourTable[Number of Days] <= 15 && yourTable[Action] <= 3, "blue", yourTable[Number of Days] >= 15 && yourTable[Action] > 3, "Orange", "Violet" )
Hi,
Hope this helps.
Thanks and Many Many Thanks. Learnt something new from you and Solved my Problem. I used your Formula at Many many places in my dataset and it works like Charm!!!
Thanks
Deepak
Glad to help. 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |