Forum Discussion
Days Between Dates- DAX and Column
Hello, Looking to get days between dates, my current issues is that one date is a measure and the other is a column so struggling to find the correct way to do it. I have included a screen shot...
Doc Age = DATEDIFF(Date_Selected, Document.c2g_DueDate__c, DAY)
Should be able to use:
Doc Age = ([Date_Selected] - MAX([Document.c2g_DueDate__c])) * 1.This would be a measure. Since you refer to a column, you have to wrap it in an aggregation like MIN, MAX, SUM, etc.
Should be able to use:
Doc Age = ([Date_Selected] - MAX([Document.c2g_DueDate__c])) * 1.
This would be a measure. Since you refer to a column, you have to wrap it in an aggregation like MIN, MAX, SUM, etc.