How to get a column value that contains a static text value& a dynamic text value from a ref column

[dnsia]

ORIGIN	DESTINATION	ETD	ETA	ATD	ATA	DELIVERY DATE	REMARKS
Manila	Cagayan	15-Jan	21-Jan	15/01/2023 5:32	21/01/2023 1:00	28-Jan	Pulled out at Cagayan Port
Manila	Zamboanga	20-Jan	23-Jan	21/01/2023 18:34	23/01/2023 8:12	28-Jan	Pulled out at Zamboanga Port
Manila	Zamboanga	20-Jan	23-Jan	21/01/2023 18:34	23/01/2023 8:12	10-Feb	Pulled out at Zamboanga Port
Manila	Davao	20-Jan	26-Jan	21/01/2023 18:34	28/01/2023 3:12	01-Feb	Pulled out at Davao Port
Manila	Davao	20-Jan	26-Jan	21/01/2023 18:34	28/01/2023 3:12	27-Jan	Pulled out at Davao Port
Manila	Davao	20-Jan	26-Jan	21/01/2023 18:34	28/01/2023 3:12	28-Jan	Pulled out at Davao Port
Manila	Gensan	20-Jan	28-Jan	21/01/2023 18:34	28/01/2023 3:12	30-Jan	Pulled out at Gensan Port
Manila	Gensan	20-Jan	28-Jan	21/01/2023 18:34	28/01/2023 3:12	30-Jan	Pulled out at Gensan Port
Manila	Cotabato	29-Jan	04-Feb	29/01/2023 9:06	05/02/2023 6:28	08-Feb	Pulled out at Cotabato Port
Manila	Cotabato	29-Jan	04-Feb	29/01/2023 9:06	05/02/2023 6:28		At Cotabato Port
Manila	Cotabato	29-Jan	04-Feb	29/01/2023 9:06	05/02/2023 6:28		At Cotabato Port
Manila	Cotabato	29-Jan	04-Feb	29/01/2023 9:06	05/02/2023 6:28	06-Feb	Pulled out at Cotabato Port
Manila	Cotabato	29-Jan	04-Feb	29/01/2023 9:06	05/02/2023 6:28		At Cotabato Port
Manila	Cotabato	29-Jan	04-Feb	29/01/2023 9:06	05/02/2023 6:28	06-Feb	Pulled out at Cotabato Port
Manila	Davao	05-Feb	10-Feb	05/02/2023 3:48	09/02/2023 6:18		At Davao Port
Manila	Davao	05-Feb	10-Feb	05/02/2023 3:48	09/02/2023 6:18	11-Feb	Pulled out at Davao Port
Manila	Iloilo	10-Feb	14-Feb	10/02/2023 0:00			Intransit Iloilo
Manila	Bacolod	10-Feb	15-Feb	10/02/2023 0:00			Intransit Bacolod
Manila	Bacolod	10-Feb	15-Feb				At Manila Port

I'm trying to create the 'Remarks' column.

As what can be seen, Remarks column value is dependent on the value of columns ATD, ATA and Delivery Date.

If the Delivery date is not null,  [true]Pulled out at "Destination column" Port

If Delivery date is null and ATD, ATA is not null, At "Destination column"

If ATA, Delivery date  is  null and ATD is not null, Intransit "Destination column" 

If ATD, ATA and Delivery date  is null, At "Origin" Port

[SamInogic · Accepted solution]

Hi @dnsia,

You can tryto create new column and use below DAX Expression:

Column = if(not

ISBLANK('Sample Data'[Delivery Date ]),"Pull out at " & 'Sample Data'[Destination] &

" Port",IF('Sample Data'[ATD]="" && 'Sample Data'[ATA]="" &&

ISBLANK('Sample Data'[Delivery Date ]),"At " & 'Sample Data'[Origin] &

" Port",IF('Sample Data'[ATA]="" &&

ISBLANK('Sample Data'[Delivery Date ]) && 'Sample Data'[ATD]<>"","Intransit " & 'Sample Data'[Destination],IF(ISBLANK('Sample

 Data'[Delivery Date ]) && ('Sample Data'[ATD]<>"" || 'Sample Data'[ATA]<>""),"At " & 'Sample Data'[Destination]))))

This will give result as shown in below screenshot:

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/