I've about 30 unique KPI's in a dashboard which exist for 5 different regions so about 150 master items. They all use a similar if statement to calculate time period of analysis and have only the region and KPI which are unique per KPI. I've had to make mass changes on many occasions during development which takes an extraordinary amount of time ... it really drives me crazy when I need to make a mass change knowing I could do a simple find/replace or export, find/replace in Excel, import in 10 minutes or less versus several hours of tediously changing and not knowing if I missed something, etc. Is there some tool which exists already or can we please get this added soon!?
Ex.
if(Analysis='MTD', Sum({<Region={'NA'},YearMonth={"$(=vMaxYearMonth)"}>}[Depot Labour Productivity]),
if(Analysis='PMTD', Sum({<Region={'NA'},YearMonth={"$(=vPreviousYearMonth)"}>}[Depot Labour Productivity]),
if(Analysis='YTD', Sum({<Region={'NA'},Calendar.FL_YTD={1},YearMonth=>}[Depot Labour Productivity]),
if(Analysis='PYTD', Sum({<Region={'NA'},Calendar.FL_PYTD={1},YearMonth=>}[Depot Labour Productivity]),
if(Analysis='PY', Sum({<Region={'NA'},Calendar.FL_PY={1},YearMonth=>}[Depot Labour Productivity]),'')))))