Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @AKARSEVGI ,
Please have a try.
EXCHRATE2 = IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) <> "TL" &&RELATED('SHEAD-SALHEAD'[EXCHRATE]) <= 1 &&RELATED('SHEAD-SALHEAD'[CURRENCY]) = "EUR" ,RELATED('FITEM-FINITEM'[HEXCHRATE]), IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "USD" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[USD])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "GBP" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[GBP])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "AUD" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[AUD])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "EUR" ,RELATED('SHEAD-SALHEAD'[EXCHRATE]),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "USD" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[USD])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "GBP" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[GBP])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "AUD" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[AUD])),
RELATED('SHEAD-SALHEAD'[EXCHRATE])
,
RELATED('CURRENCY'[EUR])
))))))))
Please use the correct if statement.
I have created a simple sample, please refer to it to see if it helps you.
Then create a column.
Column =
IF (
( 'SHEAD-SALHEAD'[EXCHRATE] ) <= 20
&& ( 'SHEAD-SALHEAD'[CURRENCY] ) = "EUR",
"1",
IF (
'SHEAD-SALHEAD'[CURRENCY] = "AUD"
&& 'SHEAD-SALHEAD'[EXCHRATE] >= 18,
"aUD ",
IF (
'SHEAD-SALHEAD'[CURRENCY] = "GBP"
&& 'SHEAD-SALHEAD'[EXCHRATE] <= 14,
"good gbp",
"unsatisfy"
)
)
)
The meaning of the formula:
[CURRENCY] column is equal to EUR and the value [EXCHRATE] is less than 20, then output 1, if [CURRENCY] column is equal to AUD and the value [EXCHRATE] is less than 18,then output aUD, if [CURRENCY] column is equal to GBP and the value [EXCHRATE] is less than 14,then output good gbp, All other results that do not satisfy the above conditions are output “Unsatisfy".
If I have misunderstood your meaning, please provide some simple sample data without privacy information and your desired output.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AKARSEVGI ,
Please have a try.
EXCHRATE2 = IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) <> "TL" &&RELATED('SHEAD-SALHEAD'[EXCHRATE]) <= 1 &&RELATED('SHEAD-SALHEAD'[CURRENCY]) = "EUR" ,RELATED('FITEM-FINITEM'[HEXCHRATE]), IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "USD" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[USD])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "GBP" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[GBP])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "AUD" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[AUD])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "EUR" ,RELATED('SHEAD-SALHEAD'[EXCHRATE]),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "USD" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[USD])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "GBP" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[GBP])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "AUD" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[AUD])),
RELATED('SHEAD-SALHEAD'[EXCHRATE])
,
RELATED('CURRENCY'[EUR])
))))))))
Please use the correct if statement.
I have created a simple sample, please refer to it to see if it helps you.
Then create a column.
Column =
IF (
( 'SHEAD-SALHEAD'[EXCHRATE] ) <= 20
&& ( 'SHEAD-SALHEAD'[CURRENCY] ) = "EUR",
"1",
IF (
'SHEAD-SALHEAD'[CURRENCY] = "AUD"
&& 'SHEAD-SALHEAD'[EXCHRATE] >= 18,
"aUD ",
IF (
'SHEAD-SALHEAD'[CURRENCY] = "GBP"
&& 'SHEAD-SALHEAD'[EXCHRATE] <= 14,
"good gbp",
"unsatisfy"
)
)
)
The meaning of the formula:
[CURRENCY] column is equal to EUR and the value [EXCHRATE] is less than 20, then output 1, if [CURRENCY] column is equal to AUD and the value [EXCHRATE] is less than 18,then output aUD, if [CURRENCY] column is equal to GBP and the value [EXCHRATE] is less than 14,then output good gbp, All other results that do not satisfy the above conditions are output “Unsatisfy".
If I have misunderstood your meaning, please provide some simple sample data without privacy information and your desired output.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |