topic Re: Tracking a product with launch date given country selected and non selected. in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2988334#M6420 <P>Remaining Data :&nbsp;</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Product y</TD><TD>France</TD><TD>2020-10</TD><TD>74</TD><TD>2019-01</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>Product y</TD><TD>France</TD><TD>2020-11</TD><TD>74</TD><TD>2019-01</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>Product y</TD><TD>France</TD><TD>2020-12</TD><TD>27</TD><TD>2019-01</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-01</TD><TD>8</TD><TD>2021-01</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-02</TD><TD>5</TD><TD>2021-01</TD><TD>2</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-03</TD><TD>96</TD><TD>2021-01</TD><TD>3</TD><TD>&nbsp;</TD><TD>3</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-04</TD><TD>98</TD><TD>2021-01</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-05</TD><TD>92</TD><TD>2021-01</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-06</TD><TD>42</TD><TD>2021-01</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-07</TD><TD>52</TD><TD>2021-01</TD><TD>7</TD><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-08</TD><TD>16</TD><TD>2021-01</TD><TD>8</TD><TD>&nbsp;</TD><TD>8</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-09</TD><TD>48</TD><TD>2021-01</TD><TD>9</TD><TD>&nbsp;</TD><TD>9</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-10</TD><TD>21</TD><TD>2021-01</TD><TD>10</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-11</TD><TD>95</TD><TD>2021-01</TD><TD>11</TD><TD>&nbsp;</TD><TD>11</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-12</TD><TD>9</TD><TD>2021-01</TD><TD>12</TD><TD>&nbsp;</TD><TD>12</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-01</TD><TD>2</TD><TD>2021-01</TD><TD>13</TD><TD>&nbsp;</TD><TD>13</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-02</TD><TD>81</TD><TD>2021-01</TD><TD>14</TD><TD>&nbsp;</TD><TD>14</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-03</TD><TD>40</TD><TD>2021-01</TD><TD>15</TD><TD>&nbsp;</TD><TD>15</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-04</TD><TD>22</TD><TD>2021-01</TD><TD>16</TD><TD>&nbsp;</TD><TD>16</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-05</TD><TD>64</TD><TD>2021-01</TD><TD>17</TD><TD>&nbsp;</TD><TD>17</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-06</TD><TD>88</TD><TD>2021-01</TD><TD>18</TD><TD>&nbsp;</TD><TD>18</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-03</TD><TD>61</TD><TD>2021-03</TD><TD>3</TD><TD>&nbsp;</TD><TD>3</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-04</TD><TD>49</TD><TD>2021-03</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-05</TD><TD>68</TD><TD>2021-03</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-06</TD><TD>20</TD><TD>2021-03</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-07</TD><TD>1</TD><TD>2021-03</TD><TD>7</TD><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-08</TD><TD>19</TD><TD>2021-03</TD><TD>8</TD><TD>&nbsp;</TD><TD>8</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-09</TD><TD>37</TD><TD>2021-03</TD><TD>9</TD><TD>&nbsp;</TD><TD>9</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-10</TD><TD>55</TD><TD>2021-03</TD><TD>10</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-11</TD><TD>87</TD><TD>2021-03</TD><TD>11</TD><TD>&nbsp;</TD><TD>11</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-12</TD><TD>79</TD><TD>2021-03</TD><TD>12</TD><TD>&nbsp;</TD><TD>12</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-01</TD><TD>33</TD><TD>2021-03</TD><TD>13</TD><TD>&nbsp;</TD><TD>13</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-02</TD><TD>60</TD><TD>2021-03</TD><TD>14</TD><TD>&nbsp;</TD><TD>14</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-03</TD><TD>12</TD><TD>2021-03</TD><TD>15</TD><TD>&nbsp;</TD><TD>15</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-04</TD><TD>94</TD><TD>2021-03</TD><TD>16</TD><TD>&nbsp;</TD><TD>16</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-05</TD><TD>82</TD><TD>2021-03</TD><TD>17</TD><TD>&nbsp;</TD><TD>17</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-06</TD><TD>73</TD><TD>2021-03</TD><TD>18</TD><TD>&nbsp;</TD><TD>18</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-04</TD><TD>90</TD><TD>2021-04</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-05</TD><TD>9</TD><TD>2021-04</TD><TD>2</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-06</TD><TD>22</TD><TD>2021-04</TD><TD>3</TD><TD>&nbsp;</TD><TD>3</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-07</TD><TD>38</TD><TD>2021-04</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-08</TD><TD>42</TD><TD>2021-04</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-09</TD><TD>72</TD><TD>2021-04</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-10</TD><TD>83</TD><TD>2021-04</TD><TD>7</TD><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-11</TD><TD>71</TD><TD>2021-04</TD><TD>8</TD><TD>&nbsp;</TD><TD>8</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-12</TD><TD>38</TD><TD>2021-04</TD><TD>9</TD><TD>&nbsp;</TD><TD>9</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-01</TD><TD>69</TD><TD>2021-04</TD><TD>10</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-02</TD><TD>74</TD><TD>2021-04</TD><TD>11</TD><TD>&nbsp;</TD><TD>11</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-03</TD><TD>91</TD><TD>2021-04</TD><TD>12</TD><TD>&nbsp;</TD><TD>12</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-04</TD><TD>54</TD><TD>2021-04</TD><TD>13</TD><TD>&nbsp;</TD><TD>13</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-05</TD><TD>79</TD><TD>2021-04</TD><TD>14</TD><TD>&nbsp;</TD><TD>14</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-06</TD><TD>45</TD><TD>2021-04</TD><TD>15</TD><TD>&nbsp;</TD><TD>15</TD></TR><TR><TD>Product z</TD><TD>Germany</TD><TD>2021-04</TD><TD>25</TD><TD>2021-04</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>Product z</TD><TD>Germany</TD><TD>2021-05</TD><TD>61</TD><TD>2021-04</TD><TD>2</TD><TD>&nbsp;</TD><TD>2</TD></TR></TBODY></TABLE><P>Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 26 Dec 2022 06:09:48 GMT Piyush_Ghungrud 2022-12-26T06:09:48Z Tracking a product with launch date given country selected and non selected. https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2987549#M6414 <P>Hi Community,</P><P>I am working on a Launch Tracker of products where I have data on their launch date, and sales, along with the current month and the countries where they have launched.&nbsp; I want to show the launch of the product from the earliest date in the launch when no country is selected. and when the country is selected I want to show the launch date from that specific launch date of the product in that country and there are multiple products in the data. The launch date is different for different products but it should show month tracking from the 1st month as shown below.</P><P>I was able to create the launch of the product irrespective of the country by ranking the products on the launch date and appended zero values in rank to distinct products so it shows the products have started from zero.&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_20221224_021434.png" style="width: 847px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/845979i2F2281CDA8FE9A3F/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot_20221224_021434.png" alt="Screenshot_20221224_021434.png" /></span></P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No. of Months since launch</P><P>&nbsp;</P><P>&nbsp;</P><P>Please let me know your suggestions on how I can get the launch of products in a country when a country is selected.</P><P>Thank you in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 24 Dec 2022 12:47:20 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2987549#M6414 Piyush_Ghungrud 2022-12-24T12:47:20Z Re: Tracking a product with launch date given country selected and non selected. https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2988050#M6418 <P>Please provide sample data that covers your issue or question completely. <BR /><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR />Please show the expected outcome based on the sample data you provided. <BR /><BR /><A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Sun, 25 Dec 2022 23:01:02 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2988050#M6418 lbendlin 2022-12-25T23:01:02Z Re: Tracking a product with launch date given country selected and non selected. https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2988318#M6419 <TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Product</TD><TD>Country</TD><TD>Month</TD><TD>Val</TD><TD>Launch Date</TD><TD>RANKing Group</TD><TD>rank</TD><TD>Test</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-06</TD><TD>0</TD><TD>&nbsp;</TD><TD>6</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-07</TD><TD>0</TD><TD>&nbsp;</TD><TD>7</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-08</TD><TD>0</TD><TD>&nbsp;</TD><TD>8</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-09</TD><TD>0</TD><TD>&nbsp;</TD><TD>9</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-10</TD><TD>0</TD><TD>&nbsp;</TD><TD>10</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-11</TD><TD>0</TD><TD>&nbsp;</TD><TD>11</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-12</TD><TD>0</TD><TD>&nbsp;</TD><TD>12</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-01</TD><TD>0</TD><TD>&nbsp;</TD><TD>13</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-02</TD><TD>0</TD><TD>&nbsp;</TD><TD>14</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-03</TD><TD>0</TD><TD>&nbsp;</TD><TD>15</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-04</TD><TD>0</TD><TD>&nbsp;</TD><TD>16</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-05</TD><TD>0</TD><TD>&nbsp;</TD><TD>17</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-06</TD><TD>0</TD><TD>&nbsp;</TD><TD>18</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-03</TD><TD>0</TD><TD>&nbsp;</TD><TD>3</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-04</TD><TD>0</TD><TD>&nbsp;</TD><TD>4</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-05</TD><TD>0</TD><TD>&nbsp;</TD><TD>5</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-06</TD><TD>0</TD><TD>&nbsp;</TD><TD>6</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-07</TD><TD>0</TD><TD>&nbsp;</TD><TD>7</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-08</TD><TD>0</TD><TD>&nbsp;</TD><TD>8</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-09</TD><TD>0</TD><TD>&nbsp;</TD><TD>9</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-10</TD><TD>0</TD><TD>&nbsp;</TD><TD>10</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-11</TD><TD>0</TD><TD>&nbsp;</TD><TD>11</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-12</TD><TD>0</TD><TD>&nbsp;</TD><TD>12</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Product y</TD><TD>France</TD><TD>2020-07</TD><TD>90</TD><TD>2019-01</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>Product y</TD><TD>France</TD><TD>2020-08</TD><TD>68</TD><TD>2019-01</TD><TD>2</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>Product y</TD><TD>France</TD><TD>2020-09</TD><TD>5</TD><TD>2019-01</TD><TD>3</TD><TD>&nbsp;</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><DIV><DIV><SPAN>1. RANKing Group = </SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>FILTER</SPAN><SPAN>('Data','Data'[Product] = </SPAN><SPAN>EARLIER</SPAN><SPAN>('Data'[Product])),'Data'[Month],,</SPAN><SPAN>ASC</SPAN><SPAN>,Dense)</SPAN></DIV><DIV><SPAN><SPAN>2.&nbsp;</SPAN></SPAN><SPAN>Test = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>Data</SPAN><SPAN>[rank]</SPAN><SPAN>=</SPAN><SPAN>"0"</SPAN><SPAN>,</SPAN><SPAN>0</SPAN><SPAN>,</SPAN><SPAN>Data</SPAN><SPAN>[RANKing Group]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="launch tracker test.png" style="width: 848px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/846209i85F4D6198AD2B633/image-size/large?v=v2&amp;px=999" role="button" title="launch tracker test.png" alt="launch tracker test.png" /></span></SPAN></DIV><DIV><SPAN>Please find the sample data and formulas that I used to get up to this result.</SPAN></DIV><DIV><SPAN>Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></DIV></DIV> Mon, 26 Dec 2022 05:59:45 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2988318#M6419 Piyush_Ghungrud 2022-12-26T05:59:45Z Re: Tracking a product with launch date given country selected and non selected. https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2988334#M6420 <P>Remaining Data :&nbsp;</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Product y</TD><TD>France</TD><TD>2020-10</TD><TD>74</TD><TD>2019-01</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>Product y</TD><TD>France</TD><TD>2020-11</TD><TD>74</TD><TD>2019-01</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>Product y</TD><TD>France</TD><TD>2020-12</TD><TD>27</TD><TD>2019-01</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-01</TD><TD>8</TD><TD>2021-01</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-02</TD><TD>5</TD><TD>2021-01</TD><TD>2</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-03</TD><TD>96</TD><TD>2021-01</TD><TD>3</TD><TD>&nbsp;</TD><TD>3</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-04</TD><TD>98</TD><TD>2021-01</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-05</TD><TD>92</TD><TD>2021-01</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-06</TD><TD>42</TD><TD>2021-01</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-07</TD><TD>52</TD><TD>2021-01</TD><TD>7</TD><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-08</TD><TD>16</TD><TD>2021-01</TD><TD>8</TD><TD>&nbsp;</TD><TD>8</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-09</TD><TD>48</TD><TD>2021-01</TD><TD>9</TD><TD>&nbsp;</TD><TD>9</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-10</TD><TD>21</TD><TD>2021-01</TD><TD>10</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-11</TD><TD>95</TD><TD>2021-01</TD><TD>11</TD><TD>&nbsp;</TD><TD>11</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2021-12</TD><TD>9</TD><TD>2021-01</TD><TD>12</TD><TD>&nbsp;</TD><TD>12</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-01</TD><TD>2</TD><TD>2021-01</TD><TD>13</TD><TD>&nbsp;</TD><TD>13</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-02</TD><TD>81</TD><TD>2021-01</TD><TD>14</TD><TD>&nbsp;</TD><TD>14</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-03</TD><TD>40</TD><TD>2021-01</TD><TD>15</TD><TD>&nbsp;</TD><TD>15</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-04</TD><TD>22</TD><TD>2021-01</TD><TD>16</TD><TD>&nbsp;</TD><TD>16</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-05</TD><TD>64</TD><TD>2021-01</TD><TD>17</TD><TD>&nbsp;</TD><TD>17</TD></TR><TR><TD>Product x</TD><TD>France</TD><TD>2022-06</TD><TD>88</TD><TD>2021-01</TD><TD>18</TD><TD>&nbsp;</TD><TD>18</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-03</TD><TD>61</TD><TD>2021-03</TD><TD>3</TD><TD>&nbsp;</TD><TD>3</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-04</TD><TD>49</TD><TD>2021-03</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-05</TD><TD>68</TD><TD>2021-03</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-06</TD><TD>20</TD><TD>2021-03</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-07</TD><TD>1</TD><TD>2021-03</TD><TD>7</TD><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-08</TD><TD>19</TD><TD>2021-03</TD><TD>8</TD><TD>&nbsp;</TD><TD>8</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-09</TD><TD>37</TD><TD>2021-03</TD><TD>9</TD><TD>&nbsp;</TD><TD>9</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-10</TD><TD>55</TD><TD>2021-03</TD><TD>10</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-11</TD><TD>87</TD><TD>2021-03</TD><TD>11</TD><TD>&nbsp;</TD><TD>11</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2021-12</TD><TD>79</TD><TD>2021-03</TD><TD>12</TD><TD>&nbsp;</TD><TD>12</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-01</TD><TD>33</TD><TD>2021-03</TD><TD>13</TD><TD>&nbsp;</TD><TD>13</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-02</TD><TD>60</TD><TD>2021-03</TD><TD>14</TD><TD>&nbsp;</TD><TD>14</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-03</TD><TD>12</TD><TD>2021-03</TD><TD>15</TD><TD>&nbsp;</TD><TD>15</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-04</TD><TD>94</TD><TD>2021-03</TD><TD>16</TD><TD>&nbsp;</TD><TD>16</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-05</TD><TD>82</TD><TD>2021-03</TD><TD>17</TD><TD>&nbsp;</TD><TD>17</TD></TR><TR><TD>Product x</TD><TD>Germany</TD><TD>2022-06</TD><TD>73</TD><TD>2021-03</TD><TD>18</TD><TD>&nbsp;</TD><TD>18</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-04</TD><TD>90</TD><TD>2021-04</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-05</TD><TD>9</TD><TD>2021-04</TD><TD>2</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-06</TD><TD>22</TD><TD>2021-04</TD><TD>3</TD><TD>&nbsp;</TD><TD>3</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-07</TD><TD>38</TD><TD>2021-04</TD><TD>4</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-08</TD><TD>42</TD><TD>2021-04</TD><TD>5</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-09</TD><TD>72</TD><TD>2021-04</TD><TD>6</TD><TD>&nbsp;</TD><TD>6</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-10</TD><TD>83</TD><TD>2021-04</TD><TD>7</TD><TD>&nbsp;</TD><TD>7</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-11</TD><TD>71</TD><TD>2021-04</TD><TD>8</TD><TD>&nbsp;</TD><TD>8</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2021-12</TD><TD>38</TD><TD>2021-04</TD><TD>9</TD><TD>&nbsp;</TD><TD>9</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-01</TD><TD>69</TD><TD>2021-04</TD><TD>10</TD><TD>&nbsp;</TD><TD>10</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-02</TD><TD>74</TD><TD>2021-04</TD><TD>11</TD><TD>&nbsp;</TD><TD>11</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-03</TD><TD>91</TD><TD>2021-04</TD><TD>12</TD><TD>&nbsp;</TD><TD>12</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-04</TD><TD>54</TD><TD>2021-04</TD><TD>13</TD><TD>&nbsp;</TD><TD>13</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-05</TD><TD>79</TD><TD>2021-04</TD><TD>14</TD><TD>&nbsp;</TD><TD>14</TD></TR><TR><TD>Product z</TD><TD>France</TD><TD>2022-06</TD><TD>45</TD><TD>2021-04</TD><TD>15</TD><TD>&nbsp;</TD><TD>15</TD></TR><TR><TD>Product z</TD><TD>Germany</TD><TD>2021-04</TD><TD>25</TD><TD>2021-04</TD><TD>1</TD><TD>&nbsp;</TD><TD>1</TD></TR><TR><TD>Product z</TD><TD>Germany</TD><TD>2021-05</TD><TD>61</TD><TD>2021-04</TD><TD>2</TD><TD>&nbsp;</TD><TD>2</TD></TR></TBODY></TABLE><P>Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 26 Dec 2022 06:09:48 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Tracking-a-product-with-launch-date-given-country-selected-and/m-p/2988334#M6420 Piyush_Ghungrud 2022-12-26T06:09:48Z