Compare two list of string at to different dates (dynamic)

[AntoineTRICHET]

Hi everyone,

I am trying to get the difference of a list at two different date.

I have as input a table containing a field with the name of the use cases and another one containing the date.

I would like to be able to get the differences between two dates (variables) but I am struggling. The dates will be selected with slicers.
The solution I have for the moment implies the creation of 4 calculated tables and is not dynamic (take always with min and max dates without taking into consideration the slicers selection).

Thank you in advance for your support

[parry2k · Accepted solution]

@AntoineTRICHET here it is:

Value Date 1 = 
VAR __selectedDate = SELECTEDVALUE(DateTable1[Date])
VAR __table = CALCULATETABLE ( VALUES ( YourTable[UseCase]  ), YourTable[Date] = __selectedDate )
RETURN
CONCATENATEX ( __table , [UseCase], "," )

Value Date 2 = 
VAR __selectedDate = SELECTEDVALUE(DateTable2[Date])
VAR __table = CALCULATETABLE ( VALUES ( YourTable[UseCase]  ), YourTable[Date] = __selectedDate )
RETURN
CONCATENATEX ( __table , [UseCase], "," )

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@AntoineTRICHET explain with an example when you have selected two dates, it returns what value? You need to explain what you are looking for, it is not very clear from your original post, 

[AntoineTRICHET]

Please find a picture with more explanations

[parry2k]

@AntoineTRICHET you need to have two date tables to select the date and then add following measure:

Value Date 1 = 
VAR __selectedDate = SELECTEDVALUE(DateTable1[Date])
RETURN
CALCULATE ( MIN ( YourTable[UseCase] ), YourTable[Date] = __selectedDate )

Value Date 2 = 
VAR __selectedDate = SELECTEDVALUE(DateTable2[Date])
RETURN
CALCULATE ( MIN ( YourTable[UseCase] ), YourTable[Date] = __selectedDate )

You can add a date table by following my blog post here Create a basic Date table in your data model for Time Intelligence calculations | PeryTUS IT Solutio...

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[AntoineTRICHET]

Hi @parry2k 
Thank you for your prompt answer.
I completely understand your answer. But I am not sure it will return a list of use case (type text) : I don't want the "min" value, I want to see all values. And I want to have the difference between the two results of the two measures you proposed.