Future Discount

[MHTANK]

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 power bi?

[v-yanjiang-msft]

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.

[MHTANK]

Yah, it can be right for this type of data , but if I have so many categories Like Name, Age, Education , Income, members etc. Then it is possible in this or ML and AI is solution?

[v-yanjiang-msft]

Hi @MHTANK ,

Could you please show me how you sample look like? 

Best Regards,

Community Support Team _ kalyj

[MHTANK]

I have a diamonds selling and manufacturing data. In this data diamond's sale is depend on it's COLOUR,  CLARITY, CUT, FLUORESCENCE, and market trends. I am giving discounts for selling based on its categories. 

[nvprasad]

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

[MHTANK]

How is it possible? Can you guide me please.