creating new measure only shows calculated fields

[Anonymous]

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? 

[v-easonf-msft · Accepted solution]

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.

[amitchandak]

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.

refer :https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...

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.

[az38]

Hi @Anonymous 

if your start and end dates to datediff calculate placed in the same row you should use a New Column, not measure