Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.