Forum Discussion

jmspbooth's avatar
jmspbooth
Frequent Visitor
4 years ago

Count days between date rows in single column

Referenced the below thread but wasnt able to get it working for me. I have a single column thats formatted as 'Date'. I need to be able to calulate the difference between the 'Days submitted'. This ...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, jmspbooth 

 

You can try the following methods.

Column:

 

Previous Date =
MAXX (
    FILTER ( 'Table', [Date Submitted] < EARLIER ( 'Table'[Date Submitted] ) ),
    [Date Submitted]
)

Difference = 
IF([Previous Date]<>BLANK(),[Date Submitted]-[Previous Date],BLANK())

Is this the output you expect?

 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jmspbooth's avatar
jmspbooth
Frequent Visitor
4 years ago

This didnt work for me. I added more detail in my response from tackytechtom if you want to look there. Below is what I get at the end.