As @marcster_uk suggested, you can try this by using the DATEDIFF function. Few days back similar type of query was posted by one of our member onto the forum. And below is the link provided for the reference about how the solution was achieved by using the DATEDIFF function.
I’m also providing the working of the Excel as well as the PBIX file for the reference.
Hoping you find this useful and meets your requirements that you’ve looking for.
Please Note:Just click on the link to view the entire post and not on the expand/collapse button.
Hi @ray, thanks for posting your query here. A comment to this post has been tagged as “Solution”. If you have a follow-up question on this post, kindly untick the Solution box and post your comment. However, to make your question more visible, we suggest creating a new thread.