Forum Discussion

mabdelrahman76's avatar
mabdelrahman76
Helper I
4 years ago
Solved

Calculate max date value from date range

Hi, I have tracking table called "test", i am trying to to display only the most recent values for each group in column “CD_Trading_Id” regarding the value of the max Date modified. I have Date sl...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mabdelrahman76 ,

     

    If you dont want to have constant value for Status , just remove the filter in measure, like:

    Measure = 
var _max=CALCULATE(MAX('Table'[Modified]),FILTER(ALLSELECTED('Table'),[CD_Trading_Id]=MAX('Table'[CD_Trading_Id])))
return IF(MAX('Table'[Modified])=_max,1,0)

    It will work, please try.

     

    Best Regards,
    Eyelyn Qin

littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

There are several simple ways to calculate the last date in a range of values.  You could use the MAX function, LASTDATE function, or the LASTNONBLANK function.  Hope this helps!

mabdelrahman76's avatar
mabdelrahman76
Helper I
4 years ago

littlemojopuppy thanks for prompt reply, i know but i am still need to filter out non corresponding values from the matrix as what i explained in my screenshoot and the total value should be "1", therefore i am trying to find a solution to display the value for the max date in each group in my i.e. i should return "closed cases" in group "31", i might need to use differnt solution to create summerize table but the table's values need to be calculated dynamically based on date range selection from the slicer, please review my previous reply and advise?