How do I create a measure that returns the latest's month value?

[dragonus]

Hi, do know this question has been asked before, but I can't seem to have them work.

I have 3 columns, Date, Attribute, Value. Date basically shows the monthly date (01/07/2020, 01/06/2020), attribute shows different locations (eg Florida/Alabama/etc) and the Value shows the amount collected that month (eg 20.39, 20.30).

I wanted to show the latest month's collection (eg July); there should be only 1 attribute since they are unique:

Date	Attribute	Value
01/07/2020	Alabama	20.38
01/07/2020	Florida	20.30
01/07/2020	Washington	232.10
01/07/2020	Michigan	293.12

[Fowmy]

@dragonus 
Do you wanna show only the last row or the total for July in your sample data?

[dragonus]

Hi @Fowmy 

I would like to see July values for all of the attributes. Total is not needed.

[Fowmy]

@dragonus 

You can add the Following Measure to Visual Filter.

Last_Month = 
    (MAX(Data2[Date]) = CALCULATE(MAX(Data2[Date]),ALLSELECTED(Data2[Date])))*1

Did I answer your question? Mark my post as a solution! 

[dragonus]

@Fowmy 

Not too sure what I am doing wrong, but it did not help. Please see my screenshots:

Followed your filter (LatestMonth is the measure that you mentioned)

Table did not change... Still shows values that are past:

[Fowmy]

@dragonus 

Your sample data shows the date in a single column, but you have Y,M and D in separate columns, create a single data column and try. Drop The Measure in Visual Filter as I showed below.

Use my modified Mesure 

[dragonus]

I tried your solution but used New Columns instead of Measure and it worked. But was wondering why was it behaving this way?

[Fowmy · Accepted solution]

@dragonus 

Great!,

The measure works as well, hope you tried this measure 

 (MAX(Data2[Date]) = CALCULATE(MAX(Data2[Date]),ALLSELECTED(Data2[Date])))*1

If you are satisfied with my answer, please accept it as a solution so others easily find it.
Appreciate KUDOS!