Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
sakshikaul
Helper III
Helper III

To write DAX using nested if conditions

‎03-18-2021 01:52 AM

Hi,

I have a following requirement and I need to write a DAX for this


if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Abu Dhabi') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND (FINAL_CUSTOMER_NAME='Bahrain') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Dubai') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Egypt') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Iraq') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Kenya') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Mozambique' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND ( FINAL_CUSTOMER_NAME='Oman' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Qatar' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Saudi Arabia' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='South Africa' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='NAMIBIA' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='SOUTH AFRICA' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='-' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND len((FINAL_CUSTOMER_NAME ))<=1,ConsingeeName,



if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Abu Dhabi') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND (FINAL_CUSTOMER_NAME='Bahrain') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Dubai') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Egypt') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Iraq') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Kenya') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Mozambique' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND ( FINAL_CUSTOMER_NAME='Oman' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Qatar' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Saudi Arabia' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='NAMIBIA' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='SOUTH AFRICA' ),ActualShipperName,


if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='-' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND len((FINAL_CUSTOMER_NAME))<=1,ActualShipperName,


if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='South Africa' ),ActualShipperName,FINAL_CUSTOMER_NAME)

))))))))))))))))))))))))) )))) )) AS Newcustomer1

 

Please help......

Labels:
Message 1 of 5
920 Views
0
1 ACCEPTED SOLUTION
sakshikaul
Helper III
Helper III

‎03-21-2021 12:04 AM

f((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Abu Dhabi') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND (FINAL_CUSTOMER_NAME='Bahrain') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Dubai') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Egypt') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Iraq') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Kenya') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Mozambique' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND ( FINAL_CUSTOMER_NAME='Oman' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Qatar' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Saudi Arabia' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='South Africa' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='NAMIBIA' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='SOUTH AFRICA' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='-' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND len((FINAL_CUSTOMER_NAME ))<=1,ConsingeeName,



if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Abu Dhabi') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND (FINAL_CUSTOMER_NAME='Bahrain') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Dubai') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Egypt') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Iraq') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Kenya') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Mozambique' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND ( FINAL_CUSTOMER_NAME='Oman' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Qatar' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Saudi Arabia' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='NAMIBIA' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='SOUTH AFRICA' ),ActualShipperName,


if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='-' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND len((FINAL_CUSTOMER_NAME))<=1,ActualShipperName,


if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='South Africa' ),ActualShipperName,FINAL_CUSTOMER_NAME)

))))))))))))))))))))))))) )))) )) AS Newcustomer1

View solution in original post

Message 5 of 5
816 Views
0
4 REPLIES 4
sakshikaul
Helper III
Helper III

‎03-21-2021 12:04 AM

f((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Abu Dhabi') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND (FINAL_CUSTOMER_NAME='Bahrain') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Dubai') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Egypt') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Iraq') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Kenya') ,ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Mozambique' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND ( FINAL_CUSTOMER_NAME='Oman' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI' ) AND ( FINAL_CUSTOMER_NAME='Qatar' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='Saudi Arabia' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='South Africa' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='NAMIBIA' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='SOUTH AFRICA' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND (FINAL_CUSTOMER_NAME='-' ),ConsingeeName,

if((TRAFFIC_DEPT='AI' OR TRAFFIC_DEPT='OI') AND len((FINAL_CUSTOMER_NAME ))<=1,ConsingeeName,



if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Abu Dhabi') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND (FINAL_CUSTOMER_NAME='Bahrain') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Dubai') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Egypt') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Iraq') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Kenya') ,ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Mozambique' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND ( FINAL_CUSTOMER_NAME='Oman' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE' ) AND ( FINAL_CUSTOMER_NAME='Qatar' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='Saudi Arabia' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='NAMIBIA' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='SOUTH AFRICA' ),ActualShipperName,


if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='-' ),ActualShipperName,

if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND len((FINAL_CUSTOMER_NAME))<=1,ActualShipperName,


if((TRAFFIC_DEPT='AE' OR TRAFFIC_DEPT='OE') AND (FINAL_CUSTOMER_NAME='South Africa' ),ActualShipperName,FINAL_CUSTOMER_NAME)

))))))))))))))))))))))))) )))) )) AS Newcustomer1

Message 5 of 5
817 Views
0
amitchandak
Super User
Super User

‎03-18-2021 03:41 AM

@sakshikaul , Try if you can use Switch

https://www.youtube.com/watch?v=gelJWktlR80

 

Nested if seems fine, what is the issue ?

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 5
872 Views
0
sakshikaul
Helper III
Helper III
In response to amitchandak

‎03-18-2021 07:30 AM

 

 

STILL GETTING AN ERROR

SWITCH((shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Abu Dhabi"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Bahrain"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Dubai"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Egypt"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Iraq"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Kenya"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Mozambique"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Oman"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Qatar"),shpm_final_Ver4[Consignee Name]
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Saudi Arabia"),shpm_final_Ver4[Consignee Name]
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="South Africa"),shpm_final_Ver4[Consignee Name],
(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="NAMIBIA"),shpm_final_Ver4[Consignee Name]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="SOUTH AFRICA"),shpm_final_Ver4[Consignee Name]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]=""),shpm_final_Ver4[Consignee Name]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="-"),shpm_final_Ver4[Consignee Name]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AI"|| shpm_final_Ver4[TRAFFIC_DEPT]="OI") && LEN(shpm_final_Ver4[FINAL_CUSTOMER_NAME])<=1,shpm_final_Ver4[Consignee Name]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Abu Dhabi"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Bahrain"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Dubai"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Egypt"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Iraq"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Kenya"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Mozambique"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Oman"),shpm_final_Ver4[ActualShipperName]
, (shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Qatar"),shpm_final_Ver4[ActualShipperName]
, (shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Saudi Arabia"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="NAMIBIA"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="SOUTH AFRICA"),shpm_final_Ver4[ActualShipperName]
(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="Abu Dhabi"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]=""),shpm_final_Ver4[ActualShipperName]
, (shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="-"),shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && LEN(shpm_final_Ver4[FINAL_CUSTOMER_NAME])<=1,shpm_final_Ver4[ActualShipperName]
,(shpm_final_Ver4[TRAFFIC_DEPT]="AE"|| shpm_final_Ver4[TRAFFIC_DEPT]="OE") && (shpm_final_Ver4[FINAL_CUSTOMER_NAME]="South Africa"),shpm_final_Ver4[ActualShipperName],shpm_final_Ver4[FINAL_CUSTOMER_NAME])

Message 4 of 5
820 Views
0
sakshikaul
Helper III
Helper III
In response to amitchandak

‎03-18-2021 05:23 AM

This code is written in qlikview... I want to write in Power BI 

Message 3 of 5
857 Views
0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All