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 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

Need Help

4 Replies

  • 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.