Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

minimum value between 2 dates

Hello,   I want to calcule a minimum and maximum for value that i have in table X. But i want to have the minimum and maximum between 2 dates that i have in table Y.    Exemple :  Table X :  ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, Anonymous 

    Please try formula like:

    minimum =
CALCULATE (
    MIN ( TableX[Value] ),
    FILTER (
        TableX,
        TableX[ART] = SELECTEDVALUE ( TableY[ART] )
            && TableX[Date] >= SELECTEDVALUE ( TableY[Date A] )
            && TableX[Date] <= SELECTEDVALUE ( TableY[Date B] )
    )
)

    Your expected result seems to have wrong value, please check again.

    Result:

    Best Regards,
    Community Support Team _ Eason

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

MaxValue = CALCULATE(MAX(X[Value]),DATEDIFF(Y[Date A],Y[Date B],DAY),ALLEXCEPT(X,X[ART]))
MinValue = CALCULATE(MIN(X[Value]),DATEDIFF(Y[Date A],Y[Date B],DAY),ALLEXCEPT(X,X[ART]))

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello,

 

I tried your suggestion but it's donesn't work.

 

I add a exemple in the tables just to be more specific for the result that i want : 

 

Thanks for your hepl

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    3 years ago

    Hi, Anonymous 

    Please try formula like:

    minimum =
CALCULATE (
    MIN ( TableX[Value] ),
    FILTER (
        TableX,
        TableX[ART] = SELECTEDVALUE ( TableY[ART] )
            && TableX[Date] >= SELECTEDVALUE ( TableY[Date A] )
            && TableX[Date] <= SELECTEDVALUE ( TableY[Date B] )
    )
)

    Your expected result seems to have wrong value, please check again.

    Result:

    Best Regards,
    Community Support Team _ Eason