hi

[abc_777]

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 customers avail promotion = 5

5) Number of invoices generated by the promotion = 5

6) Number of times the promotion code was used = 5

If i want to ran same promotion or any other different promotion discount to any items 

i want to find if i give discount of 2 Dollar or 2% and the goal is to increase customer number or quantity or invoice number and use of promotion code

So for example,  i want to find out by giving 2 dollar or 2 % discount how could I know it may increase 2 customers, 3 invoices, 5 quantity, may use promotion code 2 times if i use keep the promotion for 10 days. 

What i mean is if i give discount 2 dollar or 2% on apple item 

then how i know 

1) How many Quantity might be sold (approx) 

2) How many days promotion I should ran (approx)

3) How many customer May avail promotion (approx)

4) How many invoices could generated by the promotion (approx)

5) How many times promotion code might used (approx)

I dont know if i am clear to make you understand or not

I hope you guys get it.

PLease help me by giving a pbix gile share. 

Thanks

[v-shex-msft]

Hi @abc_777 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[abc_777]

Hello @v-shex-msft ,

thanks for your email.

I have attached an excle file which is uploaded to google drive.

Please have a look and if you have any more things you think you can add please feel free to do so

10% discount on MRP how much sale quantity may sale and how much revenue may come and how many customers may purchase these things i want to find

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

thanks

[abc_777]

hello,

is there any way to achive it for marketing promotional purpose?

I want to give for exmaple 55 dollar off or 10% on apple so i select apple from slicer and 10% from virtual table.

how can i know giving this promotion i will get this number of customers (approx)? 

please help me from this

thnx

[abc_777]

hello,

please some one help me out from this type of marketing. please give a pbix file with sample data

thx

[abc_777]

Hello,

any luck? if some one work for marketing he/she can easily understand the requirement i think. 

please help me out

thanks 

[v-shex-msft]

HI @abc_777,

I can't view the shared link, can you please paste the dummy table here with table format? Then we can simply use them to create data model table and test coding formula.

Regards,
Xiaoxin Sheng

[abc_777]

Hello @v-shex-msft ,

thanks for your reply. here is the sample data

Item Name	Unit price MRP (Dollar)	Stock (KG)
Apple	12	80
Orange	50	90
Guava	30	70
Grape	50	60
General time sale
Item Name	Sale Quantity		Sale Price
Apple	2	2*12	24
Orange	5	5*50	250
Guava	8	8*30	240
Grape	9	9*50	450
	24		964
	Total Sale Quanity = 24		Total Sale Amount=  964
Give 10% discount on MRP on Orange and Guava only
Item Name	Unit price MRP (Dollar)	Stock (KG)	After 10% discount
Apple	12	80	10.8
Orange	50	90	45
Guava	30	70	30
Grape	30	60	30
I want to guess how much Sale quantity or amount will be sale after given 10%S discount
Item Name	Sale Quantity	Stock (KG)	Sale Price
Apple		80
Orange		90
Guava		70
Grape		60
	0		0
	Total Sale Quanity = ?		Total Sale Amount=  ?

[abc_777]

@v-shex-msft 

hello friend, any luck?

thanks

[abc_777]

Hello.

could you please someone help me out weather is it possible to do promotional campaign target assumption or how many quantity could sold or how many customer might bought. i think exact not possible but some where round 

please help me if some one already did it

thanks

[abc_777]

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]

Dear all,

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

thanks

[abc_777]

Hello,

still waiting for the solution? 

is there anyone tried this please help

thx

[abc_777 · Accepted solution]

i got solution