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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

ryan_mayu Just to confirm my understanding is correct.

The Filter function will create a virtual table for each identical Sample. Then the Maxx function will give the maximum row count for each identical Sample of the virtual table and the maximum row count of the Sample actual table that the column A is not NA. If both the max count of the tables are the same (not having NA), then the Column A is empty. 

My questions is which code specify the compare of the max count of the virtual table and the table with column that is not NA? I am a bit of confuse, appreciate if you explain the breakdown the code. 

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])