Forum Discussion
Question re Date Diff (Weeks from Today) - Not Filtering Correctly On Sunday
Hi Peppearson ,
Is that you want something like this gif shows?
Please refer the pbix file in the end.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for the reply.
This isn't quite what I had in mind - my solution needs to show the date diff from the current date from any data in the past/future.
I've actually received a working solution from stack overflow. The title of the post is Date Diff Calculating Incorrectly When Refreshed On Sunday - https://stackoverflow.com/questions/73335573/date-diff-calculating-incorrectly-when-refreshed-on-sunday.
Hi Peppearson ,
Is that you want something like this gif shows?
Please refer the pbix file in the end.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for the reply.
This isn't quite what I had in mind - my solution needs to show the date diff from the current date from any data in the past/future.
I've actually received a working solution from stack overflow. The title of the post is Date Diff Calculating Incorrectly When Refreshed On Sunday - https://stackoverflow.com/questions/73335573/date-diff-calculating-incorrectly-when-refreshed-on-sunday.