Forum Discussion
fergalom
8 years agoFrequent Visitor
WhatIf Parameter & Measures
Using a what if parameter to see the effect additional budget would have on a project. BUDGET+Additonal = 'WhatIf BUDGET'[WhatIf BUDGET Value]+sum('sage_project'[TOTAL_BUDGET]) Also have a Li...
jthomson
8 years agoSolution Sage
Could you not add a visual level filter for the last twelve months?
fergalom
8 years agoFrequent Visitor
Already using a Timeline date filter visual (as some projects 3 years, some 6 months etc) on the report, only 'WhatIf BUDGET'[WhatIf BUDGET Value] ignores this filter unlike the other values.
Perhaps because the Whatif BUDGET has no relationship to the date table?