Forum Discussion
Solved
Select Column Value based on Slicer Selection
Hi, I have following two tables Budgets and Years. On selected value of Years, I want to show the selected year budget in Selected Budget field. Selected Year is Measure Field like below and ...
Yes, you need a measure, calculated columns are only calculated at data load and are not dynamic. You could use the same formula and just wrap a MAX around each of your Budgets[Budget 2017], etc. columns. That being said, you would have an easier time if you perhaps unpivoted your budget columns and assigned them a year, then you could do it with a FILTER statement.
Yes, you need a measure, calculated columns are only calculated at data load and are not dynamic. You could use the same formula and just wrap a MAX around each of your Budgets[Budget 2017], etc. columns. That being said, you would have an easier time if you perhaps unpivoted your budget columns and assigned them a year, then you could do it with a FILTER statement.