@@learnatcloudanalytics Hi Mam Thanks for the video. I've tried applying your suggested formula in a two year data file and it is working for the first year data accurately (Jan to Dec 2021). But from 2022 Jan onwards it is showing incorrect output... Kindly help to provide suggestion in ROLLING AVERAGE YEAR FOR TWO CONTINUOUS YEAR DATA SET.
Hi Mam Thanks for the video. I've tried applying your suggested formula in a two year data file and it is working for the first year data accurately (Jan to Dec 2021). But from 2022 Jan onwards it is showing incorrect output... Kindly help to provide suggestion in ROLLING AVERAGE YEAR FOR TWO CONTINUOUS YEAR DATA SET.
Hi, For each product, how to create data as a moving average of the last 4 months. For example: United States Prod_Name - April, May, June, July are 1683,1668,776,1885. So Predict Aug as Average of the 4, then use average of May, June July, Aug as September. And a slider that can be used to do -20% to +20%. where we can check what the forecast will be in case we go -1% of the moving average or 5% of the moving average. Could you suggest how to work on this issue. Thanks in advance
Trying to calculate the 12 month rolling average for a rate (Measure). It doesn't seem to be working and is just returning the same value as the current month's value (not the average of the last 12 months).
Thank you!
can you do video on importent dax functions which frequently asked in interviews. Thanks in advance.
@Swapna: I have posted videos on several DAX functions in my channel
@@learnatcloudanalytics
For Rolling Average we have two year but I need one you rolling available
@@learnatcloudanalytics Hi Mam
Thanks for the video. I've tried applying your suggested formula in a two year data file and it is working for the first year data accurately (Jan to Dec 2021). But from 2022 Jan onwards it is showing incorrect output...
Kindly help to provide suggestion in ROLLING AVERAGE YEAR FOR TWO CONTINUOUS YEAR DATA SET.
Hi Thanks it's working
My question if two years also , first 12 months average I need , second year again it should start from Jan how to do that
Hi Mam
Thanks for the video. I've tried applying your suggested formula in a two year data file and it is working for the first year data accurately (Jan to Dec 2021). But from 2022 Jan onwards it is showing incorrect output...
Kindly help to provide suggestion in ROLLING AVERAGE YEAR FOR TWO CONTINUOUS YEAR DATA SET.
Hi, For each product, how to create data as a moving average of the last 4 months.
For example: United States Prod_Name - April, May, June, July are 1683,1668,776,1885. So Predict Aug as Average of the 4, then use average of May, June July, Aug as September. And a slider that can be used to do -20% to +20%. where we can check what the forecast will be in case we go -1% of the moving average or 5% of the moving average. Could you suggest how to work on this issue. Thanks in advance
Tysm mam
Thanks 😊
Trying to calculate the 12 month rolling average for a rate (Measure). It doesn't seem to be working and is just returning the same value as the current month's value (not the average of the last 12 months).