Trend between two selectionned dates

[Anonymous]

Hello !

I am struggling with a function i want to create. my objective is to create an indicactor which shows the trend between two selectionned dates. Thoses dates are selectionned by the user using a slicer.

As an exemple :
My table has 3 columns : Article Name - Date of sale (only the first day of each month as 01.01.18 or 02.01.2018.....) - Quantity
First case :
The user select April - May - June - July using a slicer
Second case :
The user select only April - September

What i want to do, is to show the trend (Just a number not a line) for both of selections.
Hence, it is a dynamic trend.

I don't know if it is possible to use selections of user and work with it, but it could be really useful

Thank you !

Nabil

[Omega]

Can you share sample data and the expected results? 

[Anonymous]

Hello,

Here is a sample :

I just simplfied the number of article, in my case there more than 1000...

Thank you!

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Please refer to below measure:

trend =
VAR firstdatevalue =
    CALCULATE (
        SUM ( Sample2[Quantity] ),
        FILTER ( Sample2, Sample2[Date] = MIN ( Sample2[Date] ) )
    )
VAR lastdatevalue =
    CALCULATE (
        SUM ( Sample2[Quantity] ),
        FILTER ( Sample2, Sample2[Date] = MAX ( Sample2[Date] ) )
    )
RETURN
    DIVIDE ( lastdatevalue - firstdatevalue, firstdatevalue )

Best regards,

Yuliana Gu

[Anonymous]

Hello,

It matchs perfectly my needs !

Thank you !