Forum Discussion

Krishnanidar's avatar
Krishnanidar
New Member
3 years ago
Solved

Latest modified record basis slicer selection

Hi Team,   Kindly help on below scenerio   Basis on the date selection in slicer  ,we need to show contents in the matrix that are fall within that range and along with latest among those entries...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Krishnanidar 

     

    You can try the following methods.

    Measure = 
Var _maxdate=CALCULATE(MAX('Table'[Modified date]),FILTER(ALL('Table'),[Modified date]>=MIN('Date'[Date])&&[Modified date]<=MAX('Date'[Date])))
Return
IF(SELECTEDVALUE('Table'[Modified date])=_maxdate,1,0)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Krishnanidar 

 

You can try the following methods.

Measure = 
Var _maxdate=CALCULATE(MAX('Table'[Modified date]),FILTER(ALL('Table'),[Modified date]>=MIN('Date'[Date])&&[Modified date]<=MAX('Date'[Date])))
Return
IF(SELECTEDVALUE('Table'[Modified date])=_maxdate,1,0)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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