Forum Discussion
vsslasd1
Helper III
Helper IIILookupValue 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 instead of Period=Current we need anything except for "current"
What formula do I need to use to get the minimum value of "Period" in the above statement where Period<>"current.
What formula do I need to use to get the minimum value of "Period" in the above statement where Period<>"current.
- var min_date = Minx(Filter('WIP-ALL','WIP-ALL'[Period]<>"Current"),DateValue('WIP-ALL'[Period]))
1 Reply
vsslasd1var min_date = Minx(Filter('WIP-ALL','WIP-ALL'[Period]<>"Current"),DateValue('WIP-ALL'[Period]))