Forum Discussion

aatish178's avatar
aatish178
Helper IV
2 years ago
Solved

Table visual should dynamically respond to slicer selection

Hi All, I am new to power bi., and I am in really need of your help on my below query., Plz have a look and help if possible. I have 2 tables(with no active direct relationship)., shown below: Tabl...
  • amitchandak's avatar
    2 years ago

    aatish178 , Change valid from

    var ValidFrom= FILTER(allselected('Table2'),'Table2'[Item No] = max('Table2'[Item No]) && 'Table2'[RU] = max('Table2'[RU]) && 'Table2'[ValidFrom]<=maxdate)