Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ViewP
Frequent Visitor

Rule of three and Estimation Problem

Hi!

I have a table with  Date  Store  StoreType and Cost

 

Table1 

Store  Date  StoreType Sales  Cost 

1                  mine         known  known

2                notmine      known  unknown

3

4

and so on  

 

Then I use this table to create another table by grouping sale

the table look like this 

 

 

Table 2

Sales                                         Cost

10000 (avg 5000-15000)         5000

20000 (avg 15000-25000)       7000

30000 (avg 25000-35000)       10000

40000 (avg 35000-45000)       15000

50000 (avg 45000-55000)       20000

 

The problem is Some Store is not mine  I only know their sales not cost

So I want to  create measure that take Sales for the mentioned Store as input and calculate thier cost base on rule of three or any suggestion.  

for example  Sales = 15000 output cost should be 6000

                     Sales = 48000 output cost should be 19000

 

However Table Sales is updated every month, so I cant fix number in Table 2  and  need the measure to calculate cost for other store based on my store cost  and sales  for month by month. (use JAN data for calculate JAN cost).

 

Thank you in advance and sorry for any mistyping.

 

 

 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors