Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Quarterly data from monthly data

Hello All,


I have a table where I am having data like below and I am having 20 measures.

I have my daily ,weekly and monthly data coming from table directly.

So I need to calculate quarterly in reporting side.


Since my trendtype column not having quarter value from db side so I created a table in power bi to show daily ,weekly ,monthly and quarterly values. and put in a slicer

Lets say if user selects trendtype as daily then daily data.

weekly then weekly data,

Monthly then monthly data

and qtly then qtly data.


I am not sure how to create a logic for quarter and show the quarter data when user selects quarter in the slicer

Could any one please help how to do

Below is my sample data






Super User
Super User

@Sathvik123 , Use an independent table with values week, month Quarter etc.


and the switch calculation based on selection



"Weekly", [Week Measure],

"Monthly", [Month Measure],

"Quarterly", [Quarter Measure]



Same as the old measure slicer approach:How to create a Measure Slicer:



if you have separate measure already explore field parameters



Power BI Field Parameters — A Quick way for Dynamic Visuals:
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer:

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors