output difference of text values between two dates _ slicer

[jmcouffin]

Hi all, 

I am trying to get the differences of values (text type) when I select two dates. My data would look like this. 

I managed to get the concatenated list of text through a quick measure -> last option, concatened list

but I would like to get the difference between the selected data, the output should look like this: D (on the 17),E (on the 18th)

thks for your help

[Mariusz]

Hi @jmcouffin 

You can use the below DAX Expression.

Measure = 
CONCATENATEX(
    EXCEPT(
        ALLSELECTED(YourTable[Sous-projets]),
        VALUES(YourTable[Sous-projets])
    ), 
    YourTable[Sous-projets], 
    ", "
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jmcouffin]

Hi @Mariusz,

Thanks for your reply.

It is getting me closer but not quite enough 🙂

This way I get the list of values that do not belong to my filtered dates.

What I need is to get the list of values that mismatch within that time frame, not outside.

[Mariusz]

Hi @jmcouffin 

Can You provide a data sample?

Many Thanks

Mariusz

[jmcouffin]

there you go @Mariusz 

slicer-dates-values