Table Visuals

[Anonymous]

Hi All,

I have 2 table visuals in PowerBI. 

Table 1-

Table 2-

I have the same 2 tables in excel. And this is the formula I have used in excel.

=INDEX('Planning Calendar 122921'!$A$1:$J$71,MATCH('Part Analysis'!S359,'Planning Calendar 122921'!A:A,0),10)

How can I do the same for the column 'Name' in table 1 and 'Planning Calender' in table 2 and get the Order cycle implemented in table 2?

Any help is appreciated!

Thank you!

Megha

[ValtteriN · Accepted solution]

Hi,

You could try this kind of measure:
[Measure] =
var _Selection = MAX('table2'[PLanningCalendar])
CALCULATE(MAX('table1'[Order cycle]),ALL(table1),'table1'[Name]=_Selection)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!