Forum Discussion
Need help with the DAX Calculation
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
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi lbendlin,
Thank you so much for responding.
I have uploaded the file to the following link.
Thanks,
Mithilesh
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?
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
"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?