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?
To be clear: I want 139 on all rows in "Lowest".
Regards!
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,
4 Replies
philouduvResolver III
Hey Anonymous ,
Remove all and just write :lowest = MIN(factPriceIndex[price])
Best regards,
Ps : a measure could be done if you just need 1 valueI marked this as a solution by mistake haha.
I don't think works as intended.
lowest = MIN(factPriceIndex[price]) gives me the lowest price on ALL days and ALL products.
I want the lowest price each day and on each product regardless of retailer. In the example above I want 139 on all 4 rows on that specific product and that specific date.
- philouduv
Hey 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,