Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi team,
anybody help Revenue data good prediction analytics
I HAve Revenue table With columns
Date,Fee_type,Fee_rate,Total_trasaction,Total_Amount
Here below is my sample date
What type of Prediction i will be create?
I didnt have knowdage in prediction(statistics)side
| Date | Fee_type | Fee_rate | Total_Trasaction | Total Amount |
| 22/08/2019 | A | 3 | 40 | 120 |
| 22/08/2019 | A | 3 | 20 | 60 |
| 22/08/2019 | A | 3 | 10 | 30 |
| 22/08/2019 | A | 3 | 25 | 75 |
| 22/08/2019 | A | 3 | 30 | 90 |
| 22/08/2019 | B | 5 | 5 | 25 |
| 22/08/2019 | B | 5 | 6 | 30 |
| 22/08/2019 | B | 5 | 8 | 40 |
| 22/08/2019 | B | 5 | 9 | 46 |
| 22/08/2019 | B | 5 | 20 | 100 |
| 23/08/2019 | A | 3 | 2 | 6 |
| 23/08/2019 | A | 3 | 9 | 21 |
| 23/08/2019 | A | 3 | 6 | 18 |
| 23/08/2019 | A | 3 | 22 | 66 |
| 23/08/2019 | A | 3 | 35 | 105 |
| 23/08/2019 | B | 5 | 30 | 150 |
| 23/08/2019 | B | 5 | 2 | 10 |
| 23/08/2019 | B | 5 | 4 | 20 |
| 23/08/2019 | B | 5 | 5 | 25 |
| 23/08/2019 | B | 5 | 3 | 15 |
Thanks
Shanvitha
Hi @Anonymous
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution. if not, please share more details about your question, we'd like to provide further support. thanks!
If you've fixed by your own, it would be much appreciated if you can share your solution here.
Well, you could turn ML loose on it. But, if you want it to be accurate, you would want to mash it up with external data that is relevant to your business. If you want to do it correctly, I would recommend a company called Prevedere. They have something like 3 million (mostly) publicly available datasets in their cloud-based system that they can run a correlation against your sales numbers in minutes and then provide you with a model that factors in these external influencers to provide you with predictions up to about 18 months in advance.
Im sorry but your questions is not very discriptive.
to help answer your question please refer to the following article and try to include the details needed
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Proud to be a Super User!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 81 | |
| 66 | |
| 50 | |
| 45 |