Dates in tableau can be challenging - I would suggest you spend an hour and view the video below - it is probably more than you need for this calculation (probably covered in the first 10 minutes) but you will understand the variety of date functions and the difference in the 2 date types
See the link below and go to the "Date with Roddy" video
Let me know if this helped
Can you explain a bit more on this please?
Date Splits in tableau can be done using 'DatePart' function.
If I understand your question right, I might be able to help
Thank you, I haven't discovered the TDT video library. I will check it out.
In my above example, I would like to show the total for last year on the same line as my current year Month to Month. I was just thinking about adding the date three times but can I filter it by time frame displayed. Or is there some type of hierarchy that can be used on a date?