Forum Discussion

MHTANK's avatar
MHTANK
Helper III
3 years ago

Future Discount

If I have some data of products selling with discounts. I want to know future category wise discount for sale. It gives me automatically answers "how many discount I give". Is it possible through pow...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi MHTANK ,

If you want to do a prediction of the discount in the future, we can certainly do it. The calculation also needs a logic.

For example this sample.

Suppose future discount is the average value of Discount in the last three month, create a calculated column like this:

Future Discount =
IF (
    ISBLANK ( 'Table'[Discount] ),
    AVERAGEX (
        FILTER (
            'Table',
            'Table'[Month]
                >= EARLIER ( 'Table'[Month] ) - 3
                && 'Table'[Discount] <> BLANK ()
        ),
        'Table'[Discount]
    )
)

Get the result.

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.