topic Sales of new products from the first expected sales date and 4 month ahead in DAX Commands and Tips

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

LotteLaugesen — Tue, 26 Jan 2021 09:45:18 GMT

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

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

AlB — Tue, 26 Jan 2021 10:28:41 GMT

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

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

LotteLaugesen — Tue, 26 Jan 2021 11:06:55 GMT

Thank you so much - exactly what I needed 👏