Forum Discussion

jmcouffin's avatar
jmcouffin
Regular Visitor
7 years ago

output difference of text values between two dates _ slicer

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 li...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
jmcouffin
Regular Visitor
7 years ago

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.