found just one topic about Forecast in Power Bi and I am having issues with implementing this Measure, any assistance will be appreciated, please
plus, if there is any more topics related to Forecast in Power BI kindly, share with me.
Thanks !!! and in one of the two explicit titles for Forecasting Sam makes this Measure that can not get it to work, trying in different dataset and nothing, have you worked in a forecasting scenario?!!
QUARTERLY FORECAST = CALCULATE([Revenue Total],
FILTER ( ALL(Dates),
Dates[Year] = 2020 &&
Dates[QuarterOfYear] = 3 &&
Dates[QUARTER DAY] = MIN(Dates[QUARTER DAY] ) ) ) * 1.12
i haven’t reviewed the video for a while. Are you sure you typed everything correctly?
Are you using the EDNA Date table?
What kind of error are you getting?
To help people in the forum do you have sample pbix file?
What is the title of the video that you are reviewing?
Thanks, yes I am using the same syntax
Yes I am using same Date Table
I am attaching a file with the Measures and the error,
the video is the "Project a Current Trend Forward Repeadtely - Forecasting Techniques -
I did the following
changed date year in Date table to Whole number it was a text
change gldate format in d table to match the same format as the date table
changed quarter day to not to summarize
Mark the date table as a date table
you have no data for 2021, you won’t get any results. changed to 2022 and quarter 4
i have attached the file for reference. Testing Quarterly Forecastks.pbix (140.7 KB)
also i downloaded the file related to the lab for a reference point to be able to help.