Forum Discussion

DenysKryvulskyi's avatar
DenysKryvulskyi
Regular Visitor
5 years ago
Solved

List orders between Sales plan start date & end date

Hi All!

 

Need help. I have a report with Plan & Fact of orders. 

 

I need filter this orders between Sales plan Start Date & Sales Plan End Date. 

 

Order has a Date of Sale. I need to understand which order falls within the sales plan period.

 

Many thanks!

Need Help
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    DenysKryvulskyi 

    You can follow the following pattern but I am not sure how your data model is built, anyhow please adopt this code and modify as per your model. You can click on New Table on the modeling tabl and paste it

    Order List within plan= 
FILTER(
    orders,
    orders[date of sales] >= max('Sales plan'[Start Date]) &&
    orders[date of sales] <= max('Sales plan'[End Date])
)

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    DenysKryvulskyi 

    You can follow the following pattern but I am not sure how your data model is built, anyhow please adopt this code and modify as per your model. You can click on New Table on the modeling tabl and paste it

    Order List within plan= 
FILTER(
    orders,
    orders[date of sales] >= max('Sales plan'[Start Date]) &&
    orders[date of sales] <= max('Sales plan'[End Date])
)