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:
![Issue No.2.png Issue No.2.png](/t5/image/serverpage/image-id/72343iAA1EB3F4DB08422F/image-size/large?v=v2&px=999)
Any help would be appreciated.
Regards,
Eric