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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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

@Anonymous , 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-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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