Can someone please help me understand this formula :
('FX_01_Calc_FX Rates Staging'[ADD constant: Version] [ by sum : Conversion."Group"]+ 1[ADD constant: Month, Currency, Version] [by sum : Conversion."Local"])[filter:'Set_Filter_Version Window']
How is the second part of this formula starting from ‘+1’ ensuring that the data goes to the dropdown item “Local” in the conversion list?
Best answer by Stef
Hi
I see. Imagine you would have three separate metrics:
Metric A:
'FX_01_Calc_FX Rates Staging'[ADD constant: Version] [ by sum : Conversion."Group"]
Metric B:
1[ADD constant: Month, Currency, Version] [by sum : Conversion."Local"]
Metric C:
(A+B) [filter:'Set_Filter_Version Window']
In metric C you would get the same result as in your combined formula. The + operator indeed sums the values but because they are both allocated by another item of the Conversion dimension you would never see the sum unless you’re looking at “Local” + “Group” (which does not make sense).
Hope this helps,
+12Hi
The second part will be mapped to the “Local” item in the Conversion dimension because of this piece of formula:
[by sum : Conversion."Local"]Hope this helps,
Hey
My confusion is regarding the ‘+” operator. Wouldn’t that be used for summing values? Here in this context it seems it is being used to separate values based of different list items
+12Hi
I see. Imagine you would have three separate metrics:
Metric A:
'FX_01_Calc_FX Rates Staging'[ADD constant: Version] [ by sum : Conversion."Group"]
Metric B:
1[ADD constant: Month, Currency, Version] [by sum : Conversion."Local"]
Metric C:
(A+B) [filter:'Set_Filter_Version Window']
In metric C you would get the same result as in your combined formula. The + operator indeed sums the values but because they are both allocated by another item of the Conversion dimension you would never see the sum unless you’re looking at “Local” + “Group” (which does not make sense).
Hope this helps,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.