cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

comparison of revenue

 

Hi,

 

I have the requirements appreciate your help.

 

Requirement: I have a Dataset with Financial Year, Date, Clients, Revenue, and i wish to calculate the previous month Revenue and  for each client and change% in the below table format.

2. Need your help on measures to calculate Previous month revenue of the respective client and change.

3. Need the the total revenue of the client in a year. 

 

Basically i'm comparing the total revenue of the cleint at month-month and Year-Year. I tried all the measures which were advised in google.

 

image.png

 

Regards,

Varun

4 REPLIES 4
yelsherif Member
Member

Re: comparison of revenue

You'll need first to unpivot this table to put the data in a tabular format, as an example you can create a table containing 3 columns: Client, Month and Value

In Power BI desktop you have the feature to unpivot this type of tables (look in Query Editor under Tools menu)

Then, you'll need to create your measure based on the new table structure

Re: comparison of revenue

Hi,

 

I'll correct my self,

 

In the below, I need to present the data in the attached table format in Power BI, need to present the Current Year Total Revenue, Previous Year Revenue of the client and change ( Month-Month  and Year-Year in two pages).

i already have the data set with 3 columns, Date, Financial Year, Client and Revenue.  

 

Hope i'm clear from my end, please let me know if you need a sample data representation in Power BI

 

Regards,

Varun

Re: comparison of revenue

Hi,

Could you please also help me with the measures t calculate quarter - Quarter increase in revenue) 

 

REgards,

Varun

Community Support Team
Community Support Team

Re: comparison of revenue

Hi @chandra_0202 ,

It seems that you want to calculate the Previous month revenue of the respective client and change.

If it is convenient, could you share your data sample as table format and then I could have test on it.

I would appreciate it if you could share your desired output so that we could understand your scenario better. Because I have confused what previous month value do you want to get when the current month is 2019 /1, do you want to show the value of 2018/12?

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.