Forum Discussion
Count days between date rows in single column
Hi jmspbooth ,
I just throw this one out here.
If this doesn't help, I am happy to give you some more support! Just share some sample data 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Since my company has our connection filtered I cant get to that normally and have been working through it from another PC at home. So its taking me a little longer.
When I had a small data set it worked perfectly. I ingested a larger dataset that is being filtered out by a slicer and it stopped calulcating correctly.
The source table is going to be updates by multiple different teams and I need to calculate the differene in time between submission dates per team. (i.e Team A submits 1/1/22, Team B submits 1/15/22, Team A submits 2/1/22, Now calculate the difference in time between Team A submit (1) and submit (2)). There are ~75 teams each with their own submission schedule.
Ultimately I need to make sure each team is submitting information every 30 days. So this calculation is to track that and display on a stacked area chart.