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
Super 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes, I did and I'm getting 13.88

    However, I'm curious to know how Power BI is returning 16 based on the DAX formula.

     

    I think I'm missing something in the following DAX:

     

    1 % Of Arrivals Running Total = 
    CALCULATE(
    [1 % Of Arrivals],
    FILTER(
    ALLSELECTED('Sheet2'[LEAD_TIME_NR]),
    ISONORAFTER('Sheet2'[LEAD_TIME_NR], MAX('Sheet2'[LEAD_TIME_NR]), DESC)
    )
    )
     
    Thanks,
    Mithilesh