Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I have a dataset with receipts. Each line have a receipt date, a user id which represents ther person who enter the receipt in the system, a receipt id and the general information about every product ( Category id , product id , brand id etc), another fact is that wer know the retailer for every receipt. Every line represents a single product, a sample of the data is like this
Now i have another table, which represents promo data and is like this:
The objective is to combine this two tables. I want to check that if a product in a specific receipt date was bought in promo or not.
The statements is that the
1.receipt date must be inside the start and end date of the promo
2. the retailer id of the receipt is thr same with the promo
3. of course the product id must be the same in both tables.
Please help me
Thanks
Solved! Go to Solution.
That would be a really large table. Instead of combining tables, try creating a measure to determine if a receipt qualifies.
Two steps:
If COUNTROWS > 1 then you know it was bought in a promo.
Hope this helps!
Thanks! Very good!
That would be a really large table. Instead of combining tables, try creating a measure to determine if a receipt qualifies.
Two steps:
If COUNTROWS > 1 then you know it was bought in a promo.
Hope this helps!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |