Forum Discussion
How to get quartely data from monthly data
Hello All,
I have a table which have monthly data for last 12 months.
I need to show a quarterly view also by using the monthly data I have .
Could any one suggest how to do this.
9 Replies
- ribisht17
Super User
Anonymous
Yes, you can just turn your dates to anything as below
Year = YEAR('Date'[Date ID])
Qtr = QUARTER('Date'[Date ID])
Month= MONTH('Date'[Date ID])
Do you have something like 01-Jan-2022, 01-Feb-2022 as the monthly dates, it's fine Quarter(monthly date) will fetch you the Quarters that you are looking for.....
If that is not the case, please post your view here
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 
v-henryk-mstfCommunity Support
Hi Anonymous ,
You can use the quarter function to get the quarter value corresponding to the reading date. Then select the appropriate visual to create the quarter view.
quarter = QUARTER('Time'[Month])
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- ribisht17
Guess, I said the same thing 🙂
Regards,
Ritesh
- v-henryk-mstf
Hi ribisht17 ,
Yes. Hopefully, detailed step-by-step instructions will better help him understand.😊
Best Regards,
Henry
Thanks for your answers.
I need to show my data dynamically.
Lets say if user selects trendtype as daily then daily.
weekly then weekly data,
Monthly then monthly data and qtly then qtly data.
TrendType is a field in my table which has values Daily, weekly and Monthly.
As you suggested I created calculated column for Quarter.
Could you suggest how can I change my data based on user selection like daily, weekly etc
Below is my sample data
Hi ribisht17,@v
Thanks for your answers.
I need to show my data dynamically.
Lets say if user selects trendtype as daily then daily.
weekly then weekly data,
Monthly then monthly data and qtly then qtly data.
TrendType is a field in my table which has values Daily, weekly and Monthly.
As you suggested I created calculated column for Quarter.
Could you suggest how can I change my data based on user selection like daily, weekly etc
Below is my sample data
- ribisht17
Please check this post Solved: Dynamic Date Slicer including a Week and Quarter o... - Microsoft Power BI Community
Regards,
Ritesh
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin 
mahenkj2Solution Sage
After seeing your data, it seems your data table is the mix of daily, weekly and monthly data and since quarterly data is by default not there, you are trying to get there, right?
The experts suggesting answers here are trying to use date field of your data to automatically create daily, weekly and so on.
So if you just want to use TrendType column of your data, then you should have to bring that aggregate from the source data and use that in the slicer, but this does not give the flexibility, later if you need any other granularity level, again need to go to alter source.
Better you use the date field of your data and only bring lowest granularity data, for example daily. If you do so, then by applying the suggestions already put here by v-henryk-mstf and ribisht17 can be used to create slicer to show granularity levels of interest.
Is it clear enough?
