Create measure calculate the number of months between the End Date and Today

[GhadaMehrez]

I want to calculate the number of months between the End Date and Today (Month remains to today) any help please  to add a measure for that 

[Anonymous]

Hi @GhadaMehrez ,

Please try below dax formula:

Differ_to_Today =
VAR cur_date =
    TODAY ()
VAR cur_enddate =
    SELECTEDVALUE ( 'Table'[End Date] )
RETURN
    DATEDIFF ( cur_enddate, cur_date, MONTH )

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GhadaMehrez]

Perfect but some issues as:

1- Passed end date shown as below, it should appear in minus (-).

2- in the dashboard still does not appear I don't know thy reason.

Thanks for your help

[Anonymous · Accepted solution]

Hi @GhadaMehrez ,

Answer for 1: you can format  "End Date" by format() function

Format_Enddate =
FORMAT ( 'Table'[End Date], "dd-mmm-yyyy" )

Differ_to_Today =
VAR cur_date =
    TODAY ()
VAR cur_enddate =
    SELECTEDVALUE ( 'Table'[Format_Enddate] )
RETURN
    DATEDIFF ( cur_enddate, cur_date, MONTH )

Answer for 2: I guess your Y Axis field may sum by default, please try to select "Don't summarize"

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@GhadaMehrez ,

A measure like

Sumx(Table, Datediff([End Date], Today(), Day())

or

AverageX(Table, Datediff([End Date], Today(), Day())

[GhadaMehrez]

I adjusted it as follows but still, nothing appear in the dashboard also due end date not as -number

# of Months = SUMX(IncrementalImprovement, Datediff([fls_ActualEndDate], TODAY(), DAY)

[GhadaMehrez]

@amitchandak any idea please as the data not appear in the dashboard when I add the x-axis of the measure also passed end dates not show as (-)

[GhadaMehrez]

It is not working 

no of month = Sumx(IncrementalImprovement, Datediff([fls_ActualEndDate], Today(), Day())​