cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
achentrp
Frequent Visitor

Sample Request Conversion to Sales

Hello DAX Community

 

Our company uses a 3rd Party Service to distribute samples to clients, and we are looking to measure its impact on sales. For the sake of simplicity, I've created some tables that showcase the type of data I have to work with.

 

The first is data that we receive from the 3rd Party Service

 

DateCompanySKUSamples Requested

1/7/2020

A4333-121
2/3/2020B1659-011
3/14/2020A2201-031
3/16/2020C4333-101
4/2/2020A1730-061
4/22/2020B7740-041
5/13/2020A6770-151
5/16/2020D6550-111
5/24/2020C5433-071

 

The second table is our company's sales table:

DateCompanySKUSales Amount
2/7/2020C2244-06350.00
2/16/2020B1659-011600.00
3/20/2020A2201-032730.00
4/5/2020A9954-02880.00
4/16/2020D8740-10170.00
5/1/2020B3579-085520.00
5/3/2020A2603-22800.00
5/22/2020C4333-10640.00
5/30/2020B8879-043250.00
6/5/2020A4333-12120.00
6/6/2020D6550-111100.00
6/24/2020A1730-06990.00

 

What I would like to determine is which companies are purchasing after they receive a corresponding sample from the sample service, as well as the sales volume as a result. I find this calculation quite difficult since there are 3 relationships that need to be accounted for between the two tables: Date, Company, and SKU.

 

I've pondered for a few hours on how to go about writing the DAX, but am stuck on which level to start at. Any assistance or tips would be greatly appreciated. 

3 REPLIES 3
v-yingjl
Community Support
Community Support

Hi @achentrp ,

Based on your description and data sample, not certain what is your expected output. If wants to match the company name, date and SKU at the same time, seems like there is no data in the sample which meets all the requirements.

Could you please consider sharing more details about this issue for further discussion?

 

Best Regards,

Yingjie Li

sortega
Frequent Visitor

Hello @achentrp, just to confirm, I do not know if the columns are well aligned, but the first row of the table the first table would be Company A, Sku s 433-12, requested samples s 1

achentrp
Frequent Visitor

SKU is 4333-12, everything else is correct.

 

Yea, don't know why when I input the table the alignment is all off....

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.