Request Macro

[rohithbli]

The column "name" must match with column "formula"


ex :the Value "Calculation_385057835130777604" must match in column "Formula" and must replace with column "Caption" value

"Calculation_385057835130777604" must change to "Year_Brand"

caption		name	formula
Year_Brand		[Calculation_385057835130777604]	if [Parameters].[Parameter 2] = "This year" then [Calculation_385057835129393153] elseif [Parameters].[Parameter 2] = "Current Month" then [Calculation_385057835129593858] else [Calculation_385057835129860099] END
Previous Year_		[Calculation_385057835142270982]	[Parameters].[Parameter 1]-1
ΔPY YTD_Brand		[Calculation_385057835145179143]	SUM([Calculation_385057835130777604])-SUM([Data Shown Filter (copy)])
EU_YTD		[Calculation_385057835146694665]	{ FIXED [Month],[SEGMENT] : SUM([Calculation_385057835130777604])}
Current Month_prev		[Current Month (copy)]	if year([Month]) = year([Calculation_385057835142270982]) and month([Month]) = month([Parameters].[Year (copy)]) then [Zulassungen] end
Previous_Year_Brand		[Data Shown Filter (copy)]	if [Parameters].[Parameter 2] = "This year" then [This year (copy)] elseif [Parameters].[Parameter 2] = "Current Month" then [Current Month (copy)] else [YTD (copy)] END I am looking macro to replace the duplicate values with "A" Column Values. Thanks in advance Regards Rohit

<tbody>
</tbody>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/power-bi/1060270-request-macro.html#post5091630

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).