Forum Discussion
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...
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
Super User
Super User"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?
I'm trying to find the "Average Lead Time". As per the Power BI file, I created, it shows ""Average Lead Time" as 16. The Power BI file is in the following location
Thanks,
Mithilesh