Days Between Dates- DAX and Column

[Anonymous]

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

[Anonymous · Accepted solution]

Doc Age = DATEDIFF(Date_Selected, Document.c2g_DueDate__c, DAY)

[Greg_Deckler · Accepted solution]

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. 

[Anonymous · Accepted solution]

Doc Age = DATEDIFF(Date_Selected, Document.c2g_DueDate__c, DAY)

[Anonymous]

Thanks @Anonymous you are a Ninja 

[Anonymous]

Put a like "Kudos" on my reply, thanks!