Forum Discussion

KaZeK's avatar
KaZeK
Frequent Visitor
3 years ago
Solved

Assigning range to value from not connected, different table

Dear Community,    I have a doubt and I do not have any idea how to handle it. Basically I have two tables, one of them contains thousends of raws with unique name and specific value:   name1    ...
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi KaZeK ,

     

    Please try following DAX:

     

    RangeName = MAXX(
    FILTER(
        'SR30_periods_adj',
        'SR30_periods_adj'[SR30PeriodMinValue] <= EARLIER('StockList'[SR30]) &&
        'SR30_periods_adj'[SR30PeriodMaxValue] >= EARLIER('StockList'[SR30])),
        'SR30_periods_adj'[SR30PeriodName]
)

     

     

    I think this is the result you want:

     

    Best regards,

    Yadong Fang

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

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

Hi KaZeK ,

 

Please try following DAX:

 

RangeName = MAXX(
    FILTER(
        'SR30_periods_adj',
        'SR30_periods_adj'[SR30PeriodMinValue] <= EARLIER('StockList'[SR30]) &&
        'SR30_periods_adj'[SR30PeriodMaxValue] >= EARLIER('StockList'[SR30])),
        'SR30_periods_adj'[SR30PeriodName]
)

 

 

I think this is the result you want:

 

Best regards,

Yadong Fang

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

  • KaZeK's avatar
    KaZeK
    Frequent Visitor
    3 years ago

    Dear v-yadongf-msft

     

    Thank you so much. It works perfectly!!!

     

    Regards

    KaZeK