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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.