Forum Discussion
Date difference calculation
Just create an example with several rows of similar data
Can you share a screenshot of what's happening?
Closed Power BI and tried again. I have a result but all figures high in 500 range. How can I adjust this? Comparance 25-Apr-23 to 25-Apr-23 should give a result of 0. Thanks for your help!
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 👍