Forum Discussion
Solved
Find the date difference for a single column
Hi, I have a Date field in a table. My goal is to create a new column that calculates the date difference from the previous date in # of days. For example: • 1/17/20 an...
Can someone please assist?
I have tried searching on the Community, on YouTube, and online, but I can't get this to work.
Probably 20 different formulas I've used and I still can't get this date difference to work. I've tried creating a separate column and then doing a date difference, but still nothing.
Can you clarify this please "Also, this column needs to be dynamic meaning if a value is selected in a slicer, then this new column should reflect the new calculation difference."
What is in the slicer?
If you post some sample data (not a picture) and desired outcome ,someone will help you out.