Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need help with the DAX Calculation

Hi Team,   I have a sample file. (I'm unable to attach the file over here but I can share)   Based on the data, the output generated by the below dax for "Average Lead Time" is 16.   Average Le...
"DAX "
"DAX help" DAX
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi lbendlin,

     

    I was able to break down the working of DAX. Basically, it is performing the running totals to get a distribution of lead time with respect to the average lead time. And this is done by the function ISONORAFTER

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi lbendlin,

 

You're absolutely right, it will always give 1. Actually, this was written by someone a long time back.

 

I would like to trace how the "Average Lead Time" is 16

 

Please help me.

 

Thanks,

Mithilesh

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

"Average Lead Time" is neither an average nor will it ever hit 16, at least not based on your sample data. 

 

What is the business problem you are trying to solve?