Forum Discussion

alvin199's avatar
alvin199
Helper III
2 years ago
Solved

Question on Extract Group Values

Hi all,  I have a sample dataset that has 3 columns, ID, Food-A and Food-B. I would like to create a new column called Last Meal (Yellow color). I would like to exact the group of value by Sample ...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

do not think too much about max, if you change to min, the DAX will be still working. you can separate the DAX to see the output of each part. 

 

check the output of 

maxx(FILTER('Table','Table'[Sample]=EARLIER('Table'[Sample])&&'Table'[A]<>"NA")
Anonymous's avatar
Anonymous
Not applicable
2 years ago

ryan_mayu I tried to change the virtual table to NA and it will use to evaluate the the Food-A column is empty (using the Test5 column). However, why A3 is giving NA despite A3 row will appear in the virtual table and it also become True when being used to evaluate Food-A column is empty, thus it shoud display Food-B column value, choco.

 

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    my dax is <>"NA"

    Column = if(maxx(FILTER('Table','Table'[Sample]=EARLIER('Table'[Sample])&&'Table'[A]<>"NA"),'Table'[A])="",'Table'[B],'Table'[A])