cancel
Showing results for
Did you mean:
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?

Resident Rockstar

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 😞

Resident Rockstar

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

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors