Hi Community,
I've writing a Set Analysis Expression using Exclusion and Inclusion Operators.
The Logic is working fine but I need to use more refined Expression.
This is my Data:
Load *, Num(Task_Date) AS Task_Date_Num INLINE [
Task_Date, Item_Name
21/1/2022, Bus
21/1/2022, Car
21/1/2022, Truck
21/1/2022, Train
22/1/2022, Car
22/1/2022, Truck
23/1/2022, Bus
23/1/2022, Car
23/1/2022, Truck
23/1/2022, Van
23/1/2022, Airplane
];
This is the Expression I'm using:
=CONCAT({<Item_Name=P({<Task_Date_Num={'$(=Min(Task_Date_Num))'}>})>* <Item_Name=P({<Task_Date_Num={'$(=Max(Task_Date_Num))'}>})>
-
<Item_Name=P({<Task_Date_Num={"*"}-{'$(=Min(Task_Date_Num))','$(=Max(Task_Date_Num))'}>})>} DISTINCT Item_Name,', ')
I need to replace {'$(=Min(Task_Date_Num))','$(=Max(Task_Date_Num))'}
with above expression part which has Inclusion Operator:
Item_Name=P({<Task_Date_Num={'$(=Min(Task_Date_Num))'}>})>* <Item_Name=P({<Task_Date_Num={'$(=Max(Task_Date_Num))'}>})>
and get the result.
Here is the Snapshot:
Any help would be appreciated.
Regards,
Eric