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'...
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!
