This content has been marked as final.
Show 3 replies
-
1. Re: Creating Parameter for Column Measure
maneesh.gaddam Nov 30, 2018 12:41 PM (in response to Bryan Adkison)Bryan,
Can you try this MAX(IF [Parameters].[Year 1] = [Month] THEN [Cumulative] END) ?
The aggregate can be SUM,MIN, AVG depending on the structure of your data.
-
2. Re: Creating Parameter for Column Measure
Ritesh Bisht Nov 30, 2018 7:44 PM (in response to Bryan Adkison)IF [Parameters].[Year 1] = ATTR([Month])----
Types should be same, both should be string (Is Month a Date type ? )
Ritesh
-
3. Re: Creating Parameter for Column Measure
Bryan Adkison Dec 3, 2018 7:00 AM (in response to maneesh.gaddam)Thank you!
This worked for me:
SUM(IF [Parameters].[Year 1] = [ProjectYear] THEN [Cumulative Amount] END)