What is the DAX formula, if we want to do subtraction from a specific date with a specific date. If the date format is like this 15/08/2023

1. Assuming you have two date columns named "Date1" and "Date2" in your table, and you want to calculate the difference between them in days:

DateDifferenceInDays = DATEDIFF('Table'[Date1], 'Table'[Date2], DAY)

Replace 'Table' with the actual name of your table containing the date columns.

2. If you need the result in months, you can replace DAY with MONTH:

DateDifferenceInMonths = DATEDIFF('Table'[Date1], 'Table'[Date2], MONTH)

3. If you want a simple numeric result that represents the difference in days between two dates without considering months or years, you can use the '-' operator directly:

DateDifferenceInDays = 'Table'[Date1] - 'Table'[Date2]