Measure: Calculating months between End Date to today

[GhadaMehrez]

I created new measure to calculate no. of months between End Date to today but the issue:

1- Nothing appear in the dashboard

2- due-passed end date not show as -number (-3, -5..etc)

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

 

[PaulDBrown]

Sorry, I'm not following. Can you provide a dummy PBIX file via a file sharing service?

[GhadaMehrez]

Please see below my data set including two tables (Projects {Project Name-Remaining Budget}

and (Incrementalimprovments {Actual End Date})<< this field I used in the Date Diff measure

[PaulDBrown]

PLease provide sample data or PBIX file

[GhadaMehrez]

here in the sample, I created an excel sheet as data set the same as my data model as it gets the data from the power PPM platform.

in the sample of excel it works fine but in my original dashboard I have the failure

https://drive.google.com/file/d/1m3b_PdAxJ89MDKVJ9G23tPhVXAcJ2Lxi/view?usp=sharing

[PaulDBrown]

Thanks for the file. Can you please explain what you need to calculate for the visual?

This measure returns the number of months between the month end date and current month:

Month diff = 
DATEDIFF(MAX('Table'[End Date]), TODAY(), MONTH)

[GhadaMehrez]

thanks that's what exactly I need but I don't know why in the original dashboard the values do not appear in the scatter chart as below:

[PaulDBrown]

By default, the x-axis covers the range defined by the {Month diff] measure:

To avoid this, you can use the formatting options for the axis by defining new max an min values for the range.

In my example, I've extended one month at each end of the range using the following meaures for each end of the range:

Min Month Range = 
MINX('Table', [Month diff]) -1

MAX Month Range = 
MAXX('Table', [Month diff]) +1

Which delivers this:

You might even consider inverting the x-axis so that the "future" months (-ve values) are on the right of the visual as follows (which I actually thinks makes more sense):

Or perhaps change the order of the DATEDIFF so that the past months are negative vs today (today - x months), which entails changing the max and min for the range?

I've attached the sample PBIX file

[GhadaMehrez]

Thanks for your effort It works in the sample chart but for my original chart I did all the steps you advised but still values not visible, IS it maybe because I work in the original dashboard on two tables(one for Projects and another one for customer calculation including the Actual End Date field)???