Date difference between calendar daysYou may also want to find out how many days are between two dates on the calendar. Use the date calculatorto get your age in days or measure the duration of an event.Quick conversion chart of fortnights to hour1 fortnights to hour = 336 hour...
I see, the issue seems to be related to the way the fortnight number is calculated, especially when transitioning between months. Let's adjust the FortnightNum calculation to handle this scenario better: FortnightNum =VAR StartDate = DATE(YEAR('Date Table'[Date]), 1, 1)VAR DaysFromStart...