Forum Discussion
aatish178
2 years agoHelper IV
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...
- 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)
amitchandak
2 years agoSuper User
aatish178 , Change valid from
var ValidFrom= FILTER(allselected('Table2'),'Table2'[Item No] = max('Table2'[Item No]) && 'Table2'[RU] = max('Table2'[RU]) && 'Table2'[ValidFrom]<=maxdate)
aatish178
2 years agoHelper IV
Wow Amit, the solution is working perfectly...I am really very very thankful to you...🙏 It has solved a big problem of mine