Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 u...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

Omega's avatar
Omega
Impactful Individual
7 years ago

Can you share sample data and the expected results? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello,

     

    Here is a sample :

     

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

     

     

    Thank you!

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello,

         

        It matchs perfectly my needs !

         

        Thank you !