Forum Discussion
Find the date difference for a single column
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.
I'm trying to attach a sample power bi .pbix file but I don't see the option to.
How do I attach a file?
Dropbox or similar and post the link
HotChilli I don't want to share a folder which perhaps can have confidential information. So instead, I'm sticking with the screenshot. The data is very simple.
This is done in Excel and in the Output field it's calculating the # of days difference from the previous date.
The slicer just had a way of segmenting the data from Country, Region. But I should be able to incorporate this once the new column is calculated.
Hope this helps.