Forum Discussion

AdamD123's avatar
AdamD123
Icon for Helper I rankHelper I
2 years ago

Work out average from a new measure

Hello,   I kindly had some help me to create a new measure to show the number of days between an order date and receipt date (posting date). Now I have this measure showing the days in between, I w...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

AdamD123 

you can try this

 

avg = sumx(values('Table (2)'[Dcoument_No]),[leadtime])/DISTINCTCOUNT('Table (2)'[Dcoument_No])
 
AdamD123's avatar
AdamD123
Icon for Helper I rankHelper I
2 years ago

Hi Ryan,

 

Thank you for your reply. I have tried this but seem to be getting a different result:

 

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

    could you pls provide the pbix file?

    • AdamD123's avatar
      AdamD123
      Icon for Helper I rankHelper I
      2 years ago

      Hello, sorry I am not sure how I do this and there is sensitive data which I would not be allowed to share.

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

        then you can see what's the difference between my sample data and yours. maybe you can update your sample data.