Forum Discussion
creating new measure only shows calculated fields
I am new to DAX - I'm creating a new measure to measure the time between 2 dates. In using DATEDIFF its only showing me other calculated measures and not the other date fields to select from. Why won...
Hi , Anonymous
Here is a demo :
create a measure as below:
Date Dif2 = DATEDIFF(MAX(A[Goal Date]),MAX(A[Finish]),DAY)Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserIf the are on the same table you can use datediff in a column. If they are on a different table or in you want measure then it need context.
And the pbix file: https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
look for 4 ways
amitchandakSuper User
Super UserAnonymous , does it helped. Do you need more information.