Forum Discussion
Date difference calculation
Hi, I want the numbers of whole days difference between two dates, the required date and the transaction date. Both are in two different tables. The tables are joined by an ID on workorder ID, op...
Just create an example with several rows of similar data
Might be a problem with the min transaction date - Create another column to see what the min transaction date is bringing through
Hi Doleary85,
Yes, this worked. Generated a minimum transaction calculation and this calculation is used in the Datediff. One question still left: how can I exclude days of the weekend in the date difference calculation, can you help me with that?
I think you'll need to do this a slightly different way to exclude weekends.
There's a post here on how to do it: https://community.powerbi.com/t5/Desktop/DATEDIFF-excluding-weekends/m-p/947915
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍