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,
I have a table with a lot of consultants, but I want to create a new column (created with DAX) where I categorize them based on how long they have been employed. So if the consultant has been employed for 1 month, then he is "Insertion 1m" and 2-3 months, he is "Insertion 2-3m".
I think IF statement is the solution, but I am not sure. Can anyone help?
Solved! Go to Solution.
HI @Anonymous
You can try switch, like below.
Column = VAR _months = DATEDIFF( 'YourTable'[Started ], TODAY(), MONTH ) RETURN SWITCH( TRUE(), _months = 0, "new starter", _months = 1, "1 month", _months IN { 2, 3 }, "2 to 3 months", "Over 3 months" )
HI @Anonymous
You can try switch, like below.
Column = VAR _months = DATEDIFF( 'YourTable'[Started ], TODAY(), MONTH ) RETURN SWITCH( TRUE(), _months = 0, "new starter", _months = 1, "1 month", _months IN { 2, 3 }, "2 to 3 months", "Over 3 months" )
Hey @Mariusz
That worked perfectly. But I have another problem. I want the choice options you wrote, but I also want some new options in my column which are determined by another column (not based on date). So in that same switch statement, I want to refer to another column 🙂
Thanks
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |