Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

how to fetch first value from another linked table?

Hello! I have 2 tables, linked by KEY field ("Ключ" on the picture). I need to add column, which shows the firstnonblank value Linked Issues: Key from Linked Issues table. How can I do it? ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a new column like

    Minx(filter(relatedtable('Linked Issues'), not(isblank('Linked Issues'[Linked Issues: Key])), 'Linked Issues'[Linked Issues: Key])

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

Anonymous , Try a new column like

Minx(filter(relatedtable('Linked Issues'), not(isblank('Linked Issues'[Linked Issues: Key])), 'Linked Issues'[Linked Issues: Key])