Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
Doc Age = DATEDIFF(Date_Selected, Document.c2g_DueDate__c, DAY)
Thanks @Anonymous you are a Ninja
Put a like "Kudos" on my reply, thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |