cancel
Showing results 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

Helper II

## Availability of the product in the menu

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.

 id_wpisu TypTab IdTab Document Restaurant Date Product ProductGroup Quantity 3936682592 2 32155038 PAR/32322 Restaurant A 2022-12-02 Burger Classic NAPOJE ZIMNE 1 3936682593 2 32456038 PAR/32555 Restaurant A 2022-12-03 RedBUll NAPOJE ZIMNE 1 3936682594 2 33723038 PAR/33866 Restaurant A 2022-12-10 Burger Classic NAPOJE ZIMNE 1 3936682686 2 33844038 PAR/33904 Restaurant A 2022-12-10 RedBUll NAPOJE ZIMNE 1 3936682687 2 33895038 PAR/33888 Restaurant A 2022-12-10 Coca Cola 0,2L NAPOJE ZIMNE 1 3936682688 2 34348038 PAR/34265 Restaurant A 2022-12-12 Coca Cola 0,2L NAPOJE ZIMNE 1 3936682689 2 35467038 PAR/35616 Restaurant A 2022-12-18 Burger Classic NAPOJE ZIMNE 1 3936682690 2 35948038 PAR/35989 Restaurant A 2022-12-19 RedBUll NAPOJE ZIMNE 1 3936682691 2 35951038 PAR/35994 Restaurant A 2022-12-19 Coca Cola 0,2L NAPOJE ZIMNE 1
5 REPLIES 5
Helper II

any one?

Super User

Hi. Can you show the result you want to achieve?

If you just want to calculate days, when products were sold, per product:

``days = CALCULATE(DISTINCTCOUNT(T[Date]), T[Product] = SELECTEDVALUE(T[Product]))``

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

Helper II

It;s not work :((( this "SELECTEDVALUE dont work in powerpivot 😞

Super User

You can use MAX instead of SELECTEDVALUE.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

Helper II

still not work