Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

FIRSTNONBLANK with Multiple Values only returns value for one row

Hi All, I have two tables, both of which have multiple values. Table 1:   Table 2:   Table 2 indicates whether a candidate has a placement tenure ending in the next 2 weeks, e...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi amitchandak ,

    I wasn't able to get the desired results through these two calculations.

    However I did find another calculation you have in a community thread which I tried and is working

    = maxx(filter(table, [itemname] = earlier([itemname]) && [description] <> blank()), [description] )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , The first one should give value in both rows

 

Try Min

example

Column = CALCULATE(Min(Table2[Val]), FILTER(Table2, Table1[ID] = Table2[ID]))

 

 

if needed add

Column = CALCULATE(Min(Table2[Val]), FILTER(Table2, Table1[ID] = Table2[ID] && not(ISBLANK(Table2[Val]))))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi amitchandak ,

I wasn't able to get the desired results through these two calculations.

However I did find another calculation you have in a community thread which I tried and is working

= maxx(filter(table, [itemname] = earlier([itemname]) && [description] <> blank()), [description] )