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.
Hi Guys, I am trying to calculate strange "forecast" for client which should show sum of values for current month till the end of the year - I've built this function and it works okey for non blank values. It seems that if there is no real data for example March in forecast value from February is shown instead of blank(for example if service was not provided this month) . Could you please advice how to handled blank values in forecast?
Solved! Go to Solution.
Hi,
Here's the result i got. You may download the Excel file from here.
Hope this helps.
Hi @werdinka
Could you give an example of your dataset showing on this table(or matrix?) and show me how you calculate the measure"forecast"?
Which data is orginal data and which are from your measure?
Best Regards
Maggie
Hi, I hopev this helps:
Hi,
Share the link from where i can download your Excel file.
Hi,
I'm lookig the solution for the same appreciae if you could share the related File.
REgards
Hi,
Here's the result i got. You may download the Excel file from here.
Hope this helps.
Ashish!
Thank you so much - this is perfect!
You are welcome.
Ashish, one more thing. I would like grand total to show sum of my calculated field -( I am talking about the formula I wrote in file previously) - Why they are so different ? (The last show result from sum formula)
Hi,
Your question is not clear. Do you want the Grand total appearing in column N of the image that i posted to be the summation of the numbers from column B:M?
Hi Ashih,
As I mentioned before I need also to calculate "forecast" basing on last available data for the month ( I need to show it till the end of the year) . I need it to show correct grand totals for two or more dimesnison- in this case for category and for product
Test2:=CALCULATE((CALCULATE([sumofamount],filter(all('Calendar'),Calendar[Date]=MAX(Table1[Period])))),filter(all('Calendar'),Calendar[Date]<=MAX(Calendar[Date])))
As you see below - I need grand total (and subtotals ) to show sum of shown values (as in row Total I need)
you can find my example here: https://ufile.io/efav3
Hi,
I have tried quite hard but have not found a solution to this problem. I suggest you start a new thread and share the link with me here so that i can also subscribe to it as well. May be someone else has a solution.
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |