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
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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 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