I am working on a report where I have to calculate the difference between two dates (a specific date, and today) then show the resulat in the following format 00years - 00months - 00days
Date1 - Today()
Date2 - 08/19/2020
Result to show => 1 year, 9 months and 19 days
Currently I am using the DATEDIF function inside Excel then importing the result in my Power BI report, but everyday I have to open the exel file in order to get the new update then refresh my report in Power BI.
Please is there any DAX fomula that can show the date difference in the above format.
Thank you for your reply, the formula you shared returns the format I was looking for, but when I try to calculate the difference between two dates (date1=(2020;5;1) date2=(2020;5;2)) where the the difference is only 1 day the returned result is totally different -1 year, 11 months and 1 days.