Forum Discussion
Solved
sales from different dates range
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,...
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
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
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
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