Wednesday - last edited Wednesday
I'd be extreemly grateful if someone could help with this. I have a column containing date and time information. From this I need to create a new column which shows the age based on the date (in days).
I also have a seperate dataset with a start date and end date (date and time) which I need to calculate the days between the start and end.
Solved! Go to Solution.
To calculate the age in Days:
Age = DATEDIFF(Table1[DateTimeColumn],TODAY(),DAY)
to calculate the days between the start and end.
DaysBetween = DATEDIFF(Table1[StarDate],Table1[EndDate],DAY)
Power BI Consultant--Lima Peru -Dominio Consultores