Forum Discussion

usuario112's avatar
usuario112
Frequent Visitor
2 years ago
Solved

extracting data from diferents tables

Hi, im trying to extract the first number of each subject of each student and create a new column to save them, one problem is the tables are not connected each other so i cant use RELATED (they're l...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi usuario112 ,

     

    It seems to be taking the row data for the minimum value of each, and you can check the results as follows:

    First = var _t = ADDCOLUMNS('Table',"First",MINX(FILTER(ALL('Table'),[Premer_nombre]=EARLIER([Premer_nombre])),[Calificacion]))
RETURN MINX(_t,[First])

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi usuario112 ,

 

It seems to be taking the row data for the minimum value of each, and you can check the results as follows:

First = var _t = ADDCOLUMNS('Table',"First",MINX(FILTER(ALL('Table'),[Premer_nombre]=EARLIER([Premer_nombre])),[Calificacion]))
RETURN MINX(_t,[First])

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

usuario112's avatar
usuario112
Frequent Visitor
2 years ago

It worked!, thank you so much Anonymous and also thank you Greg_Deckler for the help, i appreciate you both 😄