Future Discount

Hi,

Yes, Technically it is possible. infact we have implimented market basket analysis also in PowerBI. 

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

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.