Forum Discussion
Removefilters in columns
Hi, I want the "lowest column" to show the lowest price in price column. I want it to take into account the productkey and the datekey but ignore the Retailer. Why doesn't this formula work? ...
Hey Anonymous ,
Remove all and just write :lowest = MIN(factPriceIndex[price])
Best regards,
Ps : a measure could be done if you just need 1 valueHey Anonymous,
my mistake, I forgot to read everything
This should do the trick :lowest = CALCULATE(MIN(Sheet3[price]),FILTER(ALL(Sheet3),Sheet3[datekey] = EARLIER(Sheet3[datekey])&&Sheet3[productkey] = EARLIER(Sheet3[productkey])))
Best regards,
philouduv
Resolver III
Resolver IIIHey Anonymous ,
Remove all and just write :
lowest = MIN(factPriceIndex[price])
Best regards,
Ps : a measure could be done if you just need 1 value
Best regards,
Ps : a measure could be done if you just need 1 value