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"

[TABLE="class: cms_table, width: 1091"]
<tbody>[TR]
[TD]caption[/TD]
[TD][/TD]
[TD]name[/TD]
[TD]formula[/TD]
[/TR]
[TR]
[TD]Year_Brand[/TD]
[TD][/TD]
[TD][Calculation_385057835130777604][/TD]
[TD]if [Parameters].[Parameter 2] = "This year" then [Calculation_385057835129393153]



elseif [Parameters].[Parameter 2] = "Current Month" then [Calculation_385057835129593858]



else [Calculation_385057835129860099]



END[/TD]
[/TR]
[TR]
[TD]Previous Year_[/TD]
[TD][/TD]
[TD][Calculation_385057835142270982][/TD]
[TD][Parameters].[Parameter 1]-1[/TD]
[/TR]
[TR]
[TD]ΔPY YTD_Brand[/TD]
[TD][/TD]
[TD][Calculation_385057835145179143][/TD]
[TD]SUM([Calculation_385057835130777604])-SUM([Data Shown Filter (copy)])[/TD]
[/TR]
[TR]
[TD]EU_YTD[/TD]
[TD][/TD]
[TD][Calculation_385057835146694665][/TD]
[TD]{ FIXED [Month],[SEGMENT] : SUM([Calculation_385057835130777604])}[/TD]
[/TR]
[TR]
[TD]Current Month_prev[/TD]
[TD][/TD]
[TD][Current Month (copy)][/TD]
[TD]if year([Month]) = year([Calculation_385057835142270982]) and month([Month]) = month([Parameters].[Year (copy)]) then [Zulassungen] end[/TD]
[/TR]
[TR]
[TD]Previous_Year_Brand



[/TD]
[TD][/TD]
[TD][Data Shown Filter (copy)][/TD]
[TD]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[/TD]
[/TR]
</tbody>[/TABLE]

 

[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).