Forum Discussion

sentsara's avatar
sentsara
Icon for Helper II rankHelper II
7 years ago

Calculate Max value based on Runmonth

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

 

TRENDMONTHRunTrendMonthTIMEFRAMEmeasureidsubmeasureMeasure TypeCurrentRate
12019011PROSPECTIVEBCR Hybrid0.3862
22019022PROSPECTIVEBCR Hybrid0.392
32019033PROSPECTIVEBCR Hybrid0.41
42019044PROSPECTIVEBCR Hybrid0.4307
52019055PROSPECTIVEBCR Hybrid0.4465
62019066PROSPECTIVEBCR Hybrid0.4575
72019077PROSPECTIVEBCR Hybrid0.4733

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Have you tried LASTNONBLANK()

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    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.