- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-09-2018 08:12 AM
Hi Community,
I have to create measure for calculating a rolling 12 months for Sales. I don't have date column but i have month colum(like 1,2,3 ..12) . How can i acheive it.
Please help.
Thanks,
Paruchuri
Solved! Go to Solution.
Accepted Solutions
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-17-2018 12:03 PM
All Replies
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-09-2018 08:31 AM
Do you also have a year column?
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-09-2018 09:09 AM
No
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-09-2018 09:13 AM
Then i don't think that's possible
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-09-2018 04:24 PM
I have brought Year column and now i have concatenated Year and month column and created calculated column. Now i have the column like 201801.
How can i get the rolling 12 months.
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-09-2018 11:11 PM
You may have a look at below posts. Sample data and expected output will be helpful to provide an accurate solution.
https://community.powerbi.com/t5/Desktop/Moving-Average-for-Prev-6-Next-6-Months/td-p/171712
https://community.powerbi.com/t5/Desktop/Averages-For-The-Last-12-Months/td-p/324289
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/
Regards,
Cherie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-10-2018 08:45 AM
It doesn't helps me out.
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-10-2018 12:11 PM
If you have Year and month, you can use the function 'DATE'
https://community.powerbi.com/t5/Desktop/Trailing-12-or-Rolling-12-month-sum/td-p/164419
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-10-2018 11:05 PM
You may try with below measure. Attached the sample file. If it is not your case, please share some sample data.
Measure = CALCULATE ( SUM ( Data[Sales] ), FILTER ( ALL ( 'Data' ), 'Data'[YearMonth] >= MAX ( Data[YearMonth] ) - 11 && 'Data'[YearMonth] <= MAX ( 'Data'[YearMonth] ) ) )
Regards,
Cherie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: Creating a Rolling 12 months using Month Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-17-2018 12:03 PM