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't it show me the DATE fields I have data in?
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.
5 Replies
- az38
Community Champion
Hi Anonymous
if your start and end dates to datediff calculate placed in the same row you should use a New Column, not measure
- amitchandak
Super User
If 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
- amitchandak
Anonymous , does it helped. Do you need more information.
- v-easonf-msft
Community Support
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. - Greg_Deckler
In measures, you have to refer to columns using an aggregation like MAX, MIN, SUM, etc.
