Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

     Just create an example with several rows of similar data

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Doleary85,

 

Power BI accepts formula, however Power BI does not end calculating. Does not show data. Is there an alternative?

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Can you share a screenshot of what's happening?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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!

    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      3 years ago

      Might be a problem with the min transaction date - Create another column to see what the min transaction date is bringing through

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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?