topic Re: sales from different dates range in DAX Commands and Tips

sales from different dates range

Sofiane85 — Thu, 07 Dec 2023 13:10:00 GMT

Hi all,
i have 2 tables, "Sales" and "Target"
in the Target table there is some of products and 2 dates columns : Start Date and End Date,
please, i need to calculate the sales from "Sales" table, only for dates that are between (>= <=) the start date and end date, and only for the products that are in the Target Table (not all products of sales table)
the result needed in image

Target test

Re: sales from different dates range

Fowmy — Thu, 07 Dec 2023 13:31:27 GMT

Sofiane85

Add following culumn to your target table:

Sales = VAR __Prod = Target[Product] VAR __DateStart = Target[start date] VAR __DateEnd = Target[end date] VAR __Result = SUMX( FILTER( Sales, Sales[Product] = __Prod && Sales[Date] >= __DateStart && Sales[Date] <= __DateEnd ), Sales[Qte] ) RETURN __Result

Re: sales from different dates range

Sofiane85 — Sun, 10 Dec 2023 10:25:17 GMT

Fowmy thank you so much;

it works perfectely.
please one more thing if you want, how i can visualize this by "Seller" (i dont have a relationship between the 2 tables)
thank you again

Re: sales from different dates range

Fowmy — Sun, 10 Dec 2023 12:16:43 GMT

Sofiane85

The Seller column is in the Sales table, what is your question exactly?

Re: sales from different dates range

Sofiane85 — Sun, 10 Dec 2023 13:52:38 GMT

exactely, the seller is in the Sales table, and i want to visualize the sales by Seller and product in the date ranges
and image for exemple

Re: sales from different dates range

Fowmy — Sun, 10 Dec 2023 18:51:44 GMT

Sofiane85

You need to specify the logic to allocate the sales against the sellers. looking at your data, there is not target defined by seller, only by product level.

Re: sales from different dates range

Sofiane85 — Tue, 12 Dec 2023 15:56:51 GMT

thank you so much my friend, you helped me a lot, i adapted your measure to the sales table, and it works 👍
than you again