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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi mabdelrahman76 ,

 

According to your description, it seems that you just need to apply filters , like "Status="Closed Cases".

Can you please share your pbix file after removing sensitive data or some dummy data to help us clarify your scenario?

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mabdelrahman76's avatar
    mabdelrahman76
    Helper I
    4 years ago

    Anonymous , thanks for the responce, how can i share the BI repoort here.

     

    what i would like to achive in simple words, that i have slicer with date batwwen, and i have group and each group has values overtime, i would like to see the most receent values and sum based on the date range selection.

     

    Please let me know how can i share the BI report?

     

    Thanks

    Mohamed