Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi, I am really struggling here, so after a while, I have decided to write here.
I have created a stock balance measure, which displays a running total of stock values (basically current level + purchases - orders). My client however asked me if I was able to add there some kind of forecasting option, where he would input values, which would influence the balance.
After some thinking, I came up with the idea of adding 12 parameters, each representing a forecast for a month(today())+1 +2 +3 etc. So he could adjust the forecast for the next 12 months. However, I have run into troubles with the performance. After I have added just one parameter, it went slow... so adding 12 parameters would make one jump of the window probably.
I am probably doing something wrong when adding the parameter to the specific month (to be more specific the first day of the month).
My measure is:
Solved! Go to Solution.
One possibility would be to add a date column to each of the parameter tables, defined as
EOMONTH( TODAY(), 0) + 1
for the first month, then just increment the 0 each time for subsequent months. Link the date table to the parameter table and then your stock balance measure would be
Stock balance = [Current level] + [Purchases] - [Orders] + [Parameter 1] + [ Parameter 2]
with all the parameters included.
One possibility would be to add a date column to each of the parameter tables, defined as
EOMONTH( TODAY(), 0) + 1
for the first month, then just increment the 0 each time for subsequent months. Link the date table to the parameter table and then your stock balance measure would be
Stock balance = [Current level] + [Purchases] - [Orders] + [Parameter 1] + [ Parameter 2]
with all the parameters included.
Thanks! I am not sure if it is the most effective solution, but it solves the problem, although now I have there additional 12 tables with 1000 rows each... 😕
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |