topic Re: Products that was NOT sold in a week in DAX Commands and Tips

Products that was NOT sold in a week

agoulart — Fri, 24 Jun 2022 20:23:25 GMT

Hi all,

Does anyone have an example of how to show products that were not sold by a specific week?

Would be DAX the best approach to it?

Re: Products that was NOT sold in a week

WinterMist — Fri, 24 Jun 2022 20:40:51 GMT

Hello agoulart -

To separate items by specific weeks, check out this blog (& video).

Let me know if this is helpful to you.

https://bielite.com/blog/week-start-date-power-bi-dax/

Regards,

Nathan

Re: Products that was NOT sold in a week

Jihwan_Kim — Sat, 25 Jun 2022 07:44:03 GMT

Hi,

I am not sure how your desired outcome looks like, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

If the not-sold-products-list is needed to know, one of ways to solve is to utilize EXCEPT dax function.

Not sold products list by week: = VAR _soldproductslist = CALCULATETABLE ( VALUES ( Products[Product] ), Sales ) VAR _allproductslist = VALUES ( Products[Product] ) VAR _notsoldproductslist = EXCEPT ( _allproductslist, _soldproductslist ) RETURN CONCATENATEX ( _notsoldproductslist, Products[Product], ", " )

Re: Products that was NOT sold in a week

v-zhangti — Tue, 28 Jun 2022 01:53:58 GMT

Hi, agoulart

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

Best Regards,

Community Support Team _Charlotte

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