Good day team,
Hoping you can help me with an issue. I am trying to calculate Datedif between last sale date and today. My issue come in where the saledateid data type is whole number and i unfortunately cannot change it because of access restrictions.
is there a way to convert the data type via dax or create a new measure with the correct data type?
i created the datedif dax but it throws out an error which i presume is because the data type is difference from the “today” formula