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

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

Hi， Anonymous 

The fields in your formula don't seem to match the fields in your table.

Can you share your expected output to further explain your requirement?

Best Regards,
Community Support Team _ Eason

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

v-easonf-msft 

Hello, I shared the expected output. Can you check and give me your opinion ?

Thanks