How to Calculate dax for Quartely

[Anonymous]

Hello All,

I am new to power bi.

I have  a table where I have daily,weekly and monthly data.

I have 10 measure values

Now my requirement is in all my charts I need to show quarterly data also.

Lets say I will give a option to end user select trendtype like Daily,weekly, monthly and Quarterly .

If he selects daily then daily data, weekly weekly data,monthly monthly data and quartely quarterly data

I am already getting daily, weekly and monthly data from db.

I think I need to calculate quarterly data in power bi from the data I have (daily,weekly and Monthly)

For daily I have last 30 days data , for weekly I have last 12 weeks data and for monthly I have last 12 months.

I put some sample data here.

Could any one suggest how to do this

[Anonymous]

Hi @Anonymous ,

How do you want to display quarterly data? What is the calculation logic when you select TrendType as Quarterly? Do you need to display the data in quarters(Q1, Q2, Q3 and Q4)? Could you please provide some screenshots and some example data with Text format to illustrate your needs and the final result you want? I have created a sample pbix file(see attachment) on my side where you can add your description and desired results. You can refer the following link to upload the file in the community. Thank you.

How to upload PBI in Community

Best Regards