cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gupta_diksha
Helper II
Helper II

Create a measure to find difference between two dates

Hi everyone,

 

I want to create a measuere to find the difference in months between two dates. One date is from the dataset and the other is TODAY() function. Could anyone please suggest on how can I create this measure?

 

Thank you

 

Best Regards,

DG

1 ACCEPTED SOLUTION

If you are trying to point on your column, and if it's a one row value then try this code

Measure = DATEDIFF(MAX(Your_date),TODAY(),MONTH)

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated

View solution in original post

8 REPLIES 8
othy_bi
Resolver V
Resolver V

Hi @gupta_diksha 

You can use this code to acheive your need
Measure = DATEDIFF(Your_date,TODAY(),MONTH)

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated

It is not working for me. 

Could you please suggest some other way ?

Could you provide a data sample or a screenshot so I can understand more your need

I want to find difference of months between LAST_ORDER_DATE and TODAY() and LAST_ORDER_DATE is already in the database. but when I do MEASURE = DATEDIFF( in this place after opening bracket I'm unable to refer to column named LAST_ORDER_DATE. 

Hi ,

 

        you can use Values function. e.g  Values(LAST_ORDER_DATE) to refer the  column.

 

Thanks,

Shanthakumar

If you are trying to point on your column, and if it's a one row value then try this code

Measure = DATEDIFF(MAX(Your_date),TODAY(),MONTH)

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated

View solution in original post

Thank you so much for your help It worked.

 

Regards

You are welcome 👍

 

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!