Calculating Week on Week and Quarter on Quarter revenue change

[powerbi_newbiee]

Hi all,

I'm an absolute rookie when it comes to powerBI and I was wondering if you could help me with the below.

I have hundreds of rows of revenue data and I am trying to figure out how to calculate the WoW and QoQ revenue change, and also whether this can update itself automatically. The table I'm working with looks something like the below.

revenue	date	year	quarter	month
--	--	--	---	--
--	--	--	--	--

Please help!!!

[v-robertq-msft]

Hi, @powerbi_newbiee 

According to your description, I can’t roughly understand your requirement, you can explain the logic of the WoW and QoQ revenue change in detail.

What’s more, to ask the questions about the tips and operations in the Power BI desktop, I suggest you to go to the Power BI desktop forum to open a new case so that experts in the Power BI desktop can help you in advance.

How to Get Your Question Answered Quickly 

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.