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

    TableX: 

    ARTDate

    Value

    refe128/11/2022

    3

    refe129/11/2022

    5

    refe130/11/2022

    6

    refe101/12/2022

    7

    refe102/12/2022

    9

    refe103/12/2022

    5

    refe104/12/2022

    8

    refe228/11/2022

    4

    refe230/11/2022

    7

    refe202/12/2022

    10

    refe203/12/2022

    17

     

    TableY: 

    ARTDate ADate B

    output

    refe128/11/202230/11/2022

    3

    refe101/12/202204/12/2022

    5

    refe229/11/202230/11/2022

    4

    refe202/12/202203/12/2022

    10

  • 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