Forum Discussion
A circular dependency issue
I want to concatenate a measure and a text field but I get an "a circular dependency error"
Here is my text field (Unit) & the Measure (Actual,Target etc.....)
Unit Actual Target
# 25 50
% 8 50
€ 100 1.3M
I created a calculated column
ActualUnit = IF(Source_file_1[Unit] = "%",[ACTUALMEASURE] & " " & Source_file_1[Unit], IF(Source_file_1[Unit]= "#",[ACTUALMEASURE] & " " & Source_file_1[Unit], Source_file_1[Unit] &" " & [ACTUALMEASURE]))
output:
ActualUnit
#25
%8
€100
But when I do it in TargetUnit I get the error of a circular dependency...
I also tried using Concatenate but still...
Can anyone help?
Big THANKS!
output:
ActualUnit
#25
%8
€100
But when I do it in TargetUnit I get the error of a circular dependency...
I also tried using Concatenate but still...
TargetUnit = IF(Source_file_1[Unit] = "€" ,CONCATENATE(Source_file_1[Unit],[TARGETMEASURE]),CONCATENATE([TARGETMEASURE],Source_file_1[Unit]))
Can anyone help?
Big THANKS!
Anonymous ,
You may take a look at the following post.
1 Reply
Anonymous ,
You may take a look at the following post.