OK so I think I am missing something simple here, and it’s probably because I am just back from a two week break and my brain isn’t fully engaged just yet but anyway…
I need to exclude zeros (and negatives) from a MINX calculation and cannot figure out how to do it?
I need to create some final cost projections and want to use a variety of historical performance stats as the basis (e.g. forecast based on current performance score, best score and worst score), but for new projects I will sometimes have a zero performance score and need to exclude these values from what I am trying to achieve as this returns a result of infinity which is useless
Guessing there is a straight forward technique to add into my MINX dax formula that I have missed?