Calculate Max value based on Runmonth

[sentsara]

Hi,

Dax expression needed from the below table list :

Tablename /Dataset name: Projection

i need to derive Latest CurrentRate by considering last RunMonth  for each MeasureID field [by using calculated Measure] 

output from below is: 0.4733 from BCR Measure

TRENDMONTH	RunTrendMonth	TIMEFRAME	measureid	submeasure	Measure Type	CurrentRate
1	2019011	PROSPECTIVE	BCR		Hybrid	0.3862
2	2019022	PROSPECTIVE	BCR		Hybrid	0.392
3	2019033	PROSPECTIVE	BCR		Hybrid	0.41
4	2019044	PROSPECTIVE	BCR		Hybrid	0.4307
5	2019055	PROSPECTIVE	BCR		Hybrid	0.4465
6	2019066	PROSPECTIVE	BCR		Hybrid	0.4575
7	2019077	PROSPECTIVE	BCR		Hybrid	0.4733

[Anonymous]

Yeah... Your explanation is about as clear as mud.

If I could figure out what it is you REALLY want, maybe I could help you but with this explanation of yours.... maybe someone else will have enough time to decipher it.

Good luck.

Best
D.

[Anonymous]

Have you tried LASTNONBLANK()