Forum Discussion
Need help on Dax formula
Hi santoshfx,
Thank you for reaching out to the Microsoft fabric community forum. I reproduced the scenario again, and it worked on my end. I used my sample data and successfully implemented it.
outcome:
For 101, the immediate subsequent row will be with ID 8. This is why the priority is set to low.
I am also including .pbix file for your better understanding, please have a look into it:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Super UserPlease provide more details. What do you consider working days and do you have a holiday list?
What should happen when assignees change? Show first or last one?
What should happen when the priority changes? Show highest one or last one?
When a new request is created it has Status as New
Later on it can have any other status like (Assigned, In Progress, Open, Closed, Rejected) and there is no sequence
No of working days should be calculated based on Created Date when the status was New and the Date reported when status first got changed.
In the output, I want to see Request ID, No of Days.
Additionally, Assignee, Priority & Team (details from changed record)