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

     

     

Fowmy's avatar
Fowmy
Super User
2 years ago

Sofiane85 

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

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
    Super 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