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.
Greg_Deckler
Community Champion
Community ChampionIn measures, you have to refer to columns using an aggregation like MAX, MIN, SUM, etc.