Forum Discussion

Post Patron

1 year ago

Solved

Date Difference between 2 columns same table.

I'm trying to show the date difference between 2 columns in the same table. Exampe I'm wanting to show how many days between "Initial Ruling Date" and "Final Ruling Date" Initial Ruling Date Fi...

Need Help

MarkLaf
1 year ago
Add a custom column and use Duration.TotalDays, like:

Duration.TotalDays( [Final Ruling Date] - [Initial Ruling Date] )

When doing addition with dates, you'll get a duration as an output. This function converts that duration to # days.

Output would look like the following. Note that if the initial or final date are null, then the custom column will also be null. I added nulls to your initial data to show this.

v-lgarikapat

Community Support

1 year ago

Hi inglexjc ,

Thanks for reaching out to the Microsoft fabric community forum.

MarkLaf , MasonMA

Thanks for your prompt response

inglexjc

Another workaround to achieve this is by using Power Query, where you can simply select the two date columns and subtract one from the other to calculate the difference.

I have uploaded the file for your review. Please let us know if you need any assistance or modifications we’re happy to help.