October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi
I am creating a dashboard for a Service Desk
We receive requests and now and then they can stay open for long.
I am looking to create a column to show me some Day Ranges
I created a Column called Days Since which shows us how long the request has been open for,
Now, I need to create a column to show me these Days in Ranges of;
1. Less than 20 Days open
2. Between 30 and 60 Days open
3. More than 90 Days open
Been trying to use the IF function, but I am really not coming right
I tried the below with no luck
Anyone that can help?
Solved! Go to Solution.
@jankiex are you getting a wrong result or error? What is not working? What is Days Since? Is it a column or a measure?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |