Calculate last 3 month max sales

[Vijay_patel]

Hi,

Please can someone help to figure out , how to calculate, max sales in last 3 months?.

I have colum of ship date, product , sold qty,

the shipping date is in days

THanks in advance.

[Jihwan_Kim]

Hi, 

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Max qty in last 3 months: =
IF (
    HASONEVALUE ( 'Product'[Product] ),
    MAXX (
        DATESINPERIOD ( 'Calendar'[Date], LASTDATE ( 'Calendar'[Date] ), -3, MONTH ),
        [QTY total:]
    )
)

[Vijay_patel]

Hi there,

thanks for looking into this, but I have different data. If you can help me to amend below code to get desired results.

below codes sums the last 3 months sales whereas I need max qty

sokd in last 3 month.