Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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?
Hi @MHTANK ,
Could you please show me how you sample look like?
Best Regards,
Community Support Team _ kalyj
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.
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
How is it possible? Can you guide me please.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |