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 of my Report page so far,
so the Date_Selected card is a dax formuler
Date_Selected = CALCULATE(MAX('Transaction Line Item'[CreatedDate]),ALLSELECTED('Transaction Line Item'))
This returns the date selected in the slicer to the left of it.
I then want to add a column at the end of the table which figures out the age in days so the formular should be
Doc Age = Date_Selected - Document.c2g_DueDate__c
The issue I have is that this returns another date where I need it to return a number,
Any help is appriciated.
Thanks
Dobby_Libr3
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.
4 Replies
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.