Monthly data to quarterly in dax

[Anonymous]

Hello All,

I have a table having monthly data like below and I need to calculate the quarterly data based on monthly .

and need to show quarter start date as date for each quarter like below

Not sure how to write dax for this

Could any one please help how to do as I am new to power BI.

	Date	Sales
	1/1/2022	200	Q1
	2/1/2022	100
	3/1/2022	400
	4/1/2022	500	Q2
	5/1/2022	300
	6/1/2022	700
	7/1/2022	600	Q3
	8/1/2022	800
Requirement
Quaerterly
	Date	Sales
	1/1/2022	700
	4/1/2022	1500
	7/1/2022	1400

[johnt75]

Create a proper date table with columns for quarter, start of quarter, and anything else you might want to slice on, then link that to your fact table. For the start of quarter column you can use the STARTOFQUARTER function.