Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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?    ...
Need Help
  • philouduv's avatar
    philouduv
    4 years ago

    Hey Anonymous ,

    Remove all and just write : 

    lowest = MIN(factPriceIndex[price])

    Best regards,

    Ps : a measure could be done if you just need 1 value
  • philouduv's avatar
    philouduv
    4 years ago

    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,
philouduv's avatar
philouduv
Icon for Resolver III rankResolver III
4 years ago

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,
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Now we are talking! 🙂 

     

    Thank you very much!