Forum Discussion
Table Visuals
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
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!
1 Reply
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!