A calculated Column where fields are defined by a number in a different field
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:
1 to 4
5 to 10
More Than 11
(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