Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago
Solved

hi

hello,   Can someone help me   I have 6 parameter I have an item call Apple   1) Item quantity = 10 KG 2) Item Amount = 50 Dollar 3) Number of days promotion ran =10 days 4) Number of custo...
Need Help
  • abc_777's avatar
    abc_777
    2 years ago

    i got solution

abc_777's avatar
abc_777
Solution Specialist
2 years ago

i have uploaded a pbix file to 

https://drive.google.com/drive/folders/17TuU_yxVJ5ua_ItWCMctb6NONM4QIDAJ?usp=drive_link

 

if some one can check and confirm this is the correct way to do. 

 

I divide total sale with 365 without promotion

divide total sale with 365 with promotion

divide total promotion by with promotion + without promotion and take to percentage

then found the expected sale quantity.

 

if some on can check my measures would be greate

 

thanks

abc_777's avatar
abc_777
Solution Specialist
2 years ago

Dear all,

 

this is too hard to find out this type of query in power bi?

 

thanks

  • abc_777's avatar
    abc_777
    Solution Specialist
    2 years ago

    Hello,

     

    still waiting for the solution? 

    is there anyone tried this please help

     

    thx

  • abc_777's avatar
    abc_777
    Solution Specialist
    2 years ago

    i got solution