Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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... 😕
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |