cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sathvik123
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

 

 

Sathvik123_0-1669605394747.png

 

 

1 REPLY 1
amitchandak
Super User
Super User

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

 

and the switch calculation based on selection

 

Switch(selectedvalue(Param[Period]),

"Weekly", [Week Measure],

"Monthly", [Month Measure],

"Quarterly", [Quarter Measure]

)

 

Same as the old measure slicer approach:How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M

 

 

if you have separate measure already explore field parameters

 

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors