Forum Discussion
Order Conversion efficiency Buckets
Hello ,
Need help with dax
I am Struggling to create buckets of order day count in current month (eg. count of days where order order conversion efficiency is greates than 95 % ).
I have order table and shipment table order table has order qty column and shipment table has shipment qty column,
I have created order conversion efficiency using dax - divide(sum(ordertable[order qty],sum(shipmenttable[ship qty),0).
thanks in advance
Hi SanchitGodse
Take a look at the linked video, it seems a similar scenario :
https://www.youtube.com/watch?v=DxQX6K8L6hUIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
2 Replies
Hi SanchitGodse
Take a look at the linked video, it seems a similar scenario :
https://www.youtube.com/watch?v=DxQX6K8L6hUIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
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
