Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi community!
I have a big problem with coding, hope you can help me with it!
I have many products, each product has diffrent launch date in multiple countries, one category, one company, one type and multiple sales dates with diffrent value
Some products sharing the same category, type, code, launch date.
Month No column is ranking the sales date based on how it is so far from the launch date.
I want to make a market share measure, so the final visual chart be like this:
Example of my data:
Code | Country | Company | Type | Product | Category | Launch Date | Sales Date | Value | DateDiff | Month No |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | March 2018 | 1242 | 34 | Month 34 |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | April 2018 | 93 | 35 | Month 35 |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | May 2018 | 553 | 36 | Month 36 |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | June 2018 | 286 | 37 | Month 37 |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | July 2018 | 1070 | 38 | Month 38 |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | August 2018 | 409 | 39 | Month 39 |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | September 2018 | 129 | 40 | Month 40 |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | October 2018 | 137 | 41 | Month 41 |
B0x1 | USA | X | A | ABC | BBB01xaV | June 2015 | November 2018 | 640 | 42 | Month 42 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | March 2018 | 123 | 1 | Month 1 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | April 2018 | 453 | 2 | Month 2 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | May 2018 | 200 | 3 | Month 3 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | June 2018 | 812 | 4 | Month 4 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | July 2018 | 91 | 5 | Month 5 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | August 2018 | 9284 | 6 | Month 6 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | September 2018 | 88 | 7 | Month 7 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | October 2018 | 102 | 8 | Month 8 |
B0x1 | Canada | X | A | ABC | BBB01xaV | March 2018 | November 2018 | 83 | 9 | Month 9 |
B0x1 | USA | Y | B | Z8193819 | BBB01xaV | January 2003 | January 2018 | 3123 | 181 | Month 181 |
B0x1 | USA | Y | B | Z8193819 | BBB01xaV | January 2003 | February 2018 | 7012 | 182 | Month 182 |
B0x1 | USA | Y | B | Z8193819 | BBB01xaV | January 2003 | March 2018 | 5779 | 183 | Month 183 |
B0x1 | USA | Y | B | Z8193819 | BBB01xaV | January 2003 | April 2018 | 5013 | 184 | Month 184 |
B0x1 | USA | Y | B | Z8193819 | BBB01xaV | January 2003 | May 2018 | 8762 | 185 | Month 185 |
B0x1 | USA | Y | B | Z8193819 | BBB01xaV | January 2003 | June 2018 | 7139 | 186 | Month 186 |
Thanks all!
Hi @n_n
Once you select a product, wouldn't code and type be already fixed?
Can you explain exactly how you'd calculate (formula I mean so that it is clear whta you need) if the selection is, for instance:
Product: ABC
Type: B
Country: USA
Code: B0x1
Company: Y
Hi @n_n
I'm still quite lost as to what needs to be done. Can you share (a sample) of your .pbix file? It would be very helpful.
Looking at what you explain earlier (my questions in red):
A) It will sum the value in Month1 (Launch date = Sales Date) in one country
In WHAT country? the one specified in the slicer?
One CODE -> Many products
One Product -> Many Code
One Type -> Many products
One Product -> Many type
How can a product have many types or many codes??
From your numerical example I understand that once you first select the product (Product1), country and launch month and then you want the denominator to be the sales of all products with the same category, code and type as product1 for the country and month selected (and then the rest of the months). Is that correct?
What for are the slicers Category, Type and Code that you show on your initial pic under "Denominator selection"? If this is already determined once you choose Category, country and launch date?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |