Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 |
any one?
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!
It;s not work :((( this "SELECTEDVALUE dont work in powerpivot 😞
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!
still not work
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
16 |
User | Count |
---|---|
28 | |
27 | |
18 | |
14 | |
14 |