Forum Discussion

Asil098's avatar
Asil098
New Member
1 year ago
Solved

calculating time

Hi Everyone, I am trying to calculate the time difference between the end_date and the start_date, and I want the result in minutes. In some observations, start_date> end_date, and I have used the i...
Need Help
  • v-tejrama's avatar
    v-tejrama
    1 year ago

    Hi Asil098,

     

    Thanks for sharing your query in detail.

     

    I have tested and reproduced your scenario in Power BI, including cases where the start_date is greater than the end_date, and I’m happy to confirm that I got the expected output exactly as per your requirement.


    I used a DAX calculated column to compute the time difference in minutes, and it successfully handles both normal and reverse date situations. The output displays positive, negative, or zero values depending on the date order, matching your requirement perfectly.

    For your convenience, I have also attached a sample .pbix file showing the complete setup with data, DAX logic, and a table visual, so you can easily review, test, or modify it as needed.


    Please find the attached .pbix file for your reference.

     

    If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.


    Best Regards,
    Tejaswi.
    Community Support

     

     

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

Hi Asil098 ,

 

I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.

 

If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.

 

Thank you.

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

Hi Asil098,

 

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

 

If the response answered your query, kindly “Accept as Solution” and Give “Kudos” to help others in the community benefit from it as well.

 

 

  • v-tejrama's avatar
    v-tejrama
    Community Support
    1 year ago

    Hi Asil098 ,

     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

     

    Thank you.