Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Trend between two selectionned dates

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

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

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Omega
Impactful Individual
Impactful Individual

Can you share sample data and the expected results? 

Anonymous
Not applicable

Hello,

 

Here is a sample :

Sample.PNG

 

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

 

 

Thank you!

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 )

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hello,

 

It matchs perfectly my needs !

 

Thank you !

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.