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

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

 

1 % Of Arrivals = divide([Stay Number of Arrivals], [1 Total Arrivals])

 

This makes no sense as it will always return 1

 

What are you trying to achieve ultimately?

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?

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

        Have you tried a graphical solution?  Here is the average lead time based on your raw data, by date, Arrival Indiator and Rooms Occ Nr.

         

        What is the point of the running totals?