Forum Discussion
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 : ...
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
Hi Anonymous , Can you share the expected output result too.