Forum Discussion

heejinyune's avatar
heejinyune
Frequent Visitor
3 years ago
Solved

Find the nearest value within the past month

Hello community!    Is anyone familiar with writing the Dax Programming to find the nearest (closest ) value in the table?   For example, My table is like this:   And I want to find the n...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, heejinyune ;

    You could create a measure as follow:

    near = 
var _aver=
AVERAGEX(FILTER(ALL('table'),EOMONTH([Model Built Date],0)=EOMONTH(TODAY(),0)),[Model built time (Mins)])
return  
MINX(SUMMARIZE(FILTER(ALL('table'),EOMONTH([Model Built Date],0)=EOMONTH(TODAY(),0)),[Model ID],"1", ABS( SUM([Model built time (Mins)])-_aver)),[Model ID])

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, heejinyune ;

You could create a measure as follow:

near = 
var _aver=
AVERAGEX(FILTER(ALL('table'),EOMONTH([Model Built Date],0)=EOMONTH(TODAY(),0)),[Model built time (Mins)])
return  
MINX(SUMMARIZE(FILTER(ALL('table'),EOMONTH([Model Built Date],0)=EOMONTH(TODAY(),0)),[Model ID],"1", ABS( SUM([Model built time (Mins)])-_aver)),[Model ID])

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.