Forum Discussion
Calculations - comparission, prediction, input
Hello. I am struggling to put some data together for a client`s dashboard (based on energy consumption)
1. Can I create an alarm when one of the fields I have is over a certain amount? For example to send an email or so? For example if x > 10.000, create alarm.
2. How can I create a consumption comparision (for example daily, weekly, monthly, yearly)?
3. I have some fields named in a way and they would like to see a different name when they hover over. I have tried to add it but the amount of characters exceed the permitted number. Is the any way I could add an "i" (information) button or so?
4. Can I create predictions? If so, how can I calculate prediction for next months based on the data I already have?
Thank you.
1 Reply
Hi Alexandra_B
Below are some of my ideas, hope they would be helpful.
1. This is possible. You can set up data alerts on gauge, KPI, or card tiles on a dashboard in Power BI Service.
Set data alerts in the Power BI service - Power BI | Microsoft Learn
Tutorial:Set data alerts on the Power BI service dashboards - Power BI | Microsoft Learn
2. This usually requires a date table in your model. Then you can use time intelligence functions or other date & time functions to calculate the results per your need. There are many blogs and videos about this target. For example,
Month over Month Calculation in Power BI using DAX - RADACAD
Power BI - Year over Year (YOY) Reports using SAMEPERIODLASTYEAR - Carl de Souza
3. Where do you want to add a specific name for a field? Can you provide an example or a screenshot to show the current result and the expected result?
4. There are many methods about calculating the forecasts, e.g. moving average, growth rate, and so on. You need to decide which one is the best for your scenario then consider how to realize that with Power BI.
Forecasting Methods - Top 4 Types, Overview, Examples (corporatefinanceinstitute.com)
Creating Forward Forecasts in Power BI Using DAX (enterprisedna.co)
Guide to Data Analysis and Accurate Forecasting in Power BI (analyticsvidhya.com)
How To Create A Forward Forecast In Power BI: Advanced Forecasting Techniques | Enterprise DNA
Forecast Future Sales Using DAX In Power BI | by Enterprise DNA | Medium
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
