As you can see, all 4 sets of dates have the same number of days between them, but different number of months. If I had to generalize from what I’m seeing, it’s working differently depending on whether the boundaries are at month beginning / end vs mid-month. Is this expected?
When you use month as period with the DateDiff function, QuickSight doesn’t take into account the day of the month. In your first row, that’s equivalent to counting the number of months between Dec 1 and Nov 1. If that’s not the result you expect, you can use day as your period and divide the result by 12.
The picture shows that the DateDiff seems to be inconsistent. The date formats are all the same. You can see that the first and fourth calculation of days are correct, but the middle two calculated days are not correct. You can see that the third and fourth days should be the same.
