Forum Discussion

Ara_Karapetyan's avatar
Ara_Karapetyan
Helper I
5 years ago
Solved

Difficulty with formulas

Hi everyone.

I am new in Power BI and experience difficulties.

I have 2 tables.

First one contains one column with unic numbers.

The second one contains 3 columns: number_from, number_to , text_string.

I need to serch the second table and return the text_string if the number is between number_from and number_to.

Please help with DAX formula or data modeling!

 

Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    If you want a measure, something like this:

    MeasureW = VAR _num = SELECTEDVALUE(TableOne[Column1])
RETURN
CALCULATE(MIN(TableTwo[text_string]) , 
  FILTER(TableTwo, TableTwo[number_from] <= _num && TableTwo[number_to] > _num ))

     

    You would pull the number column from the first table on to a table visual, then add the measure.

    Let me know how it goes.

     

    Also, next time please post data and desired result for faster answers.

     

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    5 years ago

    If you want a measure, something like this:

    MeasureW = VAR _num = SELECTEDVALUE(TableOne[Column1])
RETURN
CALCULATE(MIN(TableTwo[text_string]) , 
  FILTER(TableTwo, TableTwo[number_from] <= _num && TableTwo[number_to] > _num ))

     

    You would pull the number column from the first table on to a table visual, then add the measure.

    Let me know how it goes.

     

    Also, next time please post data and desired result for faster answers.

     

    • Ara_Karapetyan's avatar
      Ara_Karapetyan
      Helper I
      5 years ago

      Thanks a lot! Works great!

      Do you think it will work for calculated column?