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'm new to the forums so I'm not sure if this kind of task has been adressed before.
I'm trying to create a column where the fields are given a status' depening on how many days it took for a ticket to be resolved (Each ticket corresponds to one row).
In PBI desktop I have created a calculated column based of two date columns (Submitted and resolved) which produces a number.
I want to have a new column where the field is defined by that number.
I'm hoping to end up with a table with a table that looks something like this:
Status | 2016 | 2017 | 2018 |
Same Day | 1 | 4 | 2 |
1 to 4 | 3 | 5 | 12 |
5 to 10 | 5 | 6 | 5 |
More Than 11 | 6 | 5 | 3 |
(I'm aiming to use the matrix visual}
my formular looks like this and im not sure how far off the mark I am with the syntax
column =
(
IF([IvantiToCompletionDaysColumn]= (1<) , "Same Day", 0)
IF([IvantiToCompletionDaysColumn] = (1 <=> 4) ,"1 to 4", 0)
IF([IvantiToCompletionDaysColumn] = (5 <=> 10) ,"5 to 10", 0)
IF([IvantiToCompletionDaysColumn] > 11 ,"11+", 0)
)
Any help with this would be mightly appreciated
Cheers
Solved! Go to Solution.
Try this:
Category = SWITCH( TRUE(), [Days]<1, "Same Day", [Days]>=1 && [Days]<=4,"1 to 4", [Days]>=5 && [Days]<=10,"5 to 10", [Days]>=11,"11+" )
[Days] would be your column of how many days open.
Try this:
Category = SWITCH( TRUE(), [Days]<1, "Same Day", [Days]>=1 && [Days]<=4,"1 to 4", [Days]>=5 && [Days]<=10,"5 to 10", [Days]>=11,"11+" )
[Days] would be your column of how many days open.
Worked like magic!
thank you!
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |