It worked, although my dates are the week day, monday to friday, and when it gets to monday the result is incorrect, i am not sure yet why, but i think it's calculating considering sunday, and not friday.
Second, If you have holidays, you need to have a work calendar first, then add an index for work date, then use it for calculating a date difference.
And you'd better share ussample pbix file or some data sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading, That will be a better understanding of your requirement then screenshot.
Community Support Team _ Lin If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.