Create a measure to find difference between two dates

[gupta_diksha]

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

[DataVitalizer]

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

[DataVitalizer]

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

A kudos would be appreciated

[gupta_diksha]

It is not working for me. 

Could you please suggest some other way ?

[DataVitalizer]

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

[gupta_diksha]

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. 

[Anonymous]

Hi ,

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

Thanks,

Shanthakumar

[DataVitalizer · 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

[gupta_diksha]

Thank you so much for your help It worked.

Regards

[DataVitalizer]

You are welcome 👍

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

A kudos would be appreciated