topic Re: Availability of the product in the menu in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3094719#M108530 <P>still not work</P> Thu, 23 Feb 2023 07:09:08 GMT Anonymous 2023-02-23T07:09:08Z Availability of the product in the menu https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3092609#M108391 <P>Hi DAX specialists, I have a problem in a restaurant, I am researching a certain sales period, and now I would like to know over the course of, for example: 6 months, how many days a given product was on sale. Based on this availability, what is the average sale per day but in terms of the actual availability of the product (first part of my question). Sample table below I will be much obliged for your help.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>id_wpisu</TD><TD>TypTab</TD><TD>IdTab</TD><TD>Document</TD><TD>Restaurant</TD><TD>Date</TD><TD>Product</TD><TD>ProductGroup</TD><TD>Quantity</TD></TR><TR><TD>3936682592</TD><TD>2</TD><TD>32155038</TD><TD>PAR/32322</TD><TD>Restaurant A</TD><TD>2022-12-02</TD><TD>Burger Classic</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR><TR><TD>3936682593</TD><TD>2</TD><TD>32456038</TD><TD>PAR/32555</TD><TD>Restaurant A</TD><TD>2022-12-03</TD><TD>RedBUll</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR><TR><TD>3936682594</TD><TD>2</TD><TD>33723038</TD><TD>PAR/33866</TD><TD>Restaurant A</TD><TD>2022-12-10</TD><TD>Burger Classic</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR><TR><TD>3936682686</TD><TD>2</TD><TD>33844038</TD><TD>PAR/33904</TD><TD>Restaurant A</TD><TD>2022-12-10</TD><TD>RedBUll</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR><TR><TD>3936682687</TD><TD>2</TD><TD>33895038</TD><TD>PAR/33888</TD><TD>Restaurant A</TD><TD>2022-12-10</TD><TD>Coca Cola 0,2L</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR><TR><TD>3936682688</TD><TD>2</TD><TD>34348038</TD><TD>PAR/34265</TD><TD>Restaurant A</TD><TD>2022-12-12</TD><TD>Coca Cola 0,2L</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR><TR><TD>3936682689</TD><TD>2</TD><TD>35467038</TD><TD>PAR/35616</TD><TD>Restaurant A</TD><TD>2022-12-18</TD><TD>Burger Classic</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR><TR><TD>3936682690</TD><TD>2</TD><TD>35948038</TD><TD>PAR/35989</TD><TD>Restaurant A</TD><TD>2022-12-19</TD><TD>RedBUll</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR><TR><TD>3936682691</TD><TD>2</TD><TD>35951038</TD><TD>PAR/35994</TD><TD>Restaurant A</TD><TD>2022-12-19</TD><TD>Coca Cola 0,2L</TD><TD>NAPOJE ZIMNE&nbsp;</TD><TD>1</TD></TR></TBODY></TABLE> Wed, 22 Feb 2023 10:55:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3092609#M108391 Anonymous 2023-02-22T10:55:15Z Re: Availability of the product in the menu https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3093595#M108462 <P>Hi. Can you show the result you want to achieve?</P><P>If you just want to calculate days, when products were sold, per product:</P><LI-CODE lang="markup">days = CALCULATE(DISTINCTCOUNT(T[Date]), T[Product] = SELECTEDVALUE(T[Product]))</LI-CODE> Wed, 22 Feb 2023 17:17:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3093595#M108462 ERD 2023-02-22T17:17:26Z Re: Availability of the product in the menu https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3094622#M108518 <P>It;s not work :((( this "SELECTEDVALUE dont work in powerpivot <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P> Thu, 23 Feb 2023 06:06:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3094622#M108518 Anonymous 2023-02-23T06:06:14Z Re: Availability of the product in the menu https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3094712#M108529 <P>You can use MAX instead of&nbsp;<SPAN>SELECTEDVALUE.</SPAN></P> Thu, 23 Feb 2023 07:05:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3094712#M108529 ERD 2023-02-23T07:05:44Z Re: Availability of the product in the menu https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3094719#M108530 <P>still not work</P> Thu, 23 Feb 2023 07:09:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3094719#M108530 Anonymous 2023-02-23T07:09:08Z Re: Availability of the product in the menu https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3097677#M108757 <P>any one?</P> Fri, 24 Feb 2023 09:39:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Availability-of-the-product-in-the-menu/m-p/3097677#M108757 Anonymous 2023-02-24T09:39:09Z