I’m going around in circles in which i am sure is a very simple calculation but i cannot find the right formula to achieve the number of days past due based on today’s date
My data is simple
In my fact table i have a list of people who have training records and i have a completed date and a re certification date. i have a date table with a active relationship to the Completed Date in the fact table.
What i want to show is the number of days past due from the re-certification date based on today’s date for the training for any given person
So for example today is 24/06/2020 and a re-certification date is 28/03/2020 how many days have past. (with the number of days past due being dynamic based on the todays date)
I have checked out the time intelligence resource and cohort analysis course but have yet to find the information that gives me the solution im after