Forum Discussion
montibellin
Helper I
Helper IDAX add column based on comparison between two tables
Hi Guys, starting from two tables like Table 1 Col A Col B Ross 297 Brian 350 Catia 125 Danny 40 Table 2 Col A Col B 0 100 1 200 2 300 3 4...
montibellin , Create a new column in Table 1
Col C= maxx(filter('Table 2', 'Table 1'[Col B]<'Table 2'[Col B]),'Table 2'[Col A])
refer: https://youtu.be/czNHt7UXIe8
amitchandak
Super User
Super Usermontibellin , Create a new column in Table 1
Col C= maxx(filter('Table 2', 'Table 1'[Col B]<'Table 2'[Col B]),'Table 2'[Col A])
refer: https://youtu.be/czNHt7UXIe8