Forum Discussion
Solved
Date Calculations - Resulting Data Type
I'm having an issue with a calculated column in my model that subtracts a date column from todays date, where I want my end result to be 'days'. The result comes in a date format but I've used this f...
Caitlin_Knox Try doing it in Query Editor as given below.
Since this is the one who shows up on top of google, I'd like to add another solution.
Doing the calculation on LOAD sometimes doesn't quite do the job, specially if your measure may change depending on how you filter your report.
You CAN format the results in DAX likeso:
FORMAT(MAX('Date Table'[Date]) - MIN('Date Table'[Date]); "General Number")
Cheers