cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
great_AS Member
Member

DATEDIFF

Hi everybody,

 

I have a dataset where I want to compute the ageing of some items to date.

 

Basically what I want to do is very easy, it's a subtraction of the item date and TODAY() function. 

 

I tried to do it creating a measure using DATEDIFF, however when I use this function I cannot select the column field containing the item dates after the parenthesis.

 

Why I cannot use it as a measure? Should I then go to the query editor? If yes, what's the formula to use instead of DATEDIFF?

 

Thanks in advance.

 

Andrea

 

1 ACCEPTED SOLUTION

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

Re: DATEDIFF

Hi @great_AS

 

Have you tried using the DATEDIFF function in a calculated column, rather than in a calculated measure?

 

Do you hve a small sample set of data?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

3 REPLIES 3
Phil_Seamark Super Contributor
Super Contributor

Re: DATEDIFF

Hi @great_AS

 

Have you tried using the DATEDIFF function in a calculated column, rather than in a calculated measure?

 

Do you hve a small sample set of data?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

great_AS Member
Member

Re: DATEDIFF

Hi @Phil_Seamark,

 

it worked perfectly. Could you please tell me what's the difference between a measure and a calculated column?

 

Thanks in advance.

 

Cheers,

Andrea

Phil_Seamark Super Contributor
Super Contributor

Re: DATEDIFF

Hi @great_AS

 

Sure.  Here is one of the better summaries I have seen recently

 

https://community.powerbi.com/t5/Desktop/column-vs-measure/m-p/13201/highlight/true#M3304

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 85 members 1,312 guests
Please welcome our newest community members: