Forum Discussion
Lookup value based on slicer
Hello, I have 2 tables with a relationship as marked below with a red line. The green table has some special exchange rates. The second table has exchange rates by month. ExchRate is simply a c...
Anonymous , Create a measure
maxx(filter( Rate, Rate[COde] = max(Table[Code]) && Rate[ERYear] = [selected Year]) , [ERSpecial])
Thank you for your reply. I did what you said but it only returns values for the selected year in the slicer. The other years are filtered out. Please see below. I am expecting that yearly exchange rate to be attached to every single row in the monthly exchange rate table, based on the slicer selection.
Basically, if selected value in the slicer is 2023, every single row in the monthly exchange rate should get the ERspecial for 2023 and so on. have a nice day