Sales of new products from the first expected sales date and 4 month ahead

[LotteLaugesen]

Hi

I need to calculate the number of Kilos sold after Expected selling start date for each product in New Products table.

Invoice Date is date of selling.

There is relations between:

Dim_Calendar/Date and Sales/Invoice Date

Dim_Calendar/Date and New Products/Expected selling start date
Dim_Items/Item number and Sales/Item Number
Dim_Items/Item number and New Products/Item number

The report should look like this:

Can anybody help?

Best regards

Lotte

[AlB · Accepted solution]

Hi @LotteLaugesen 

Measure =
VAR startDate_ =
    SELECTEDVALUE ( NewProducts[Expected selling start date] )
VAR endDate_ =
    EDATE ( startDate_, 4 )
RETURN
    CALCULATE (
        SUM ( Sales[Kilos] ),
        Sales[Invoice date] >= startDate_ && Sales[Invoice date] <= endDate_
    )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[LotteLaugesen]

Thank you so much - exactly what I needed 👏