Forum Discussion

Sofiane85's avatar
Sofiane85
Frequent Visitor
2 years ago
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,...
Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    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's avatar
Sofiane85
Frequent Visitor
2 years ago

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

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
2 years ago

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.

  • Sofiane85's avatar
    Sofiane85
    Frequent Visitor
    2 years ago

    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