Forum Discussion

vsslasd1's avatar
vsslasd1
Icon for Helper III rankHelper III
5 years ago
Solved

LookupValue with a not equal to

Hello,  I am trying to get a DAX variable to get the minimum value similar to the following:   var min_date=LOOKUPVALUE('WIP-ALL'[Period],[Period],"Current", Min('WIP-ALL'[Period]))   But inste...
Need Help
Show and Tell
Tips and Tricks
  • vsslasd1's avatar
    vsslasd1
    5 years ago
    var min_date = Minx(Filter('WIP-ALL','WIP-ALL'[Period]<>"Current"),DateValue('WIP-ALL'[Period]))
vsslasd1's avatar
vsslasd1
Icon for Helper III rankHelper III
5 years ago
var min_date = Minx(Filter('WIP-ALL','WIP-ALL'[Period]<>"Current"),DateValue('WIP-ALL'[Period]))