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

Q-Q, M-M and Y-Y change if the Financial STARTS from Apr

Hi,

 

Could you please help me with the set of Queries to find the year on Year, Quarter on Quarter change of Revenue if the Financial Year starts from April.

 

1. I have the dataset from FY14.

2. Need to calculate the chnage of revenue from FY14 - FY15, FY-15-FY16 etc..

3. Need to Calculate the chnage of revenue from FY14-Q1 to FY14-Q2, FY14Q2 to FY14Q3 etc.... till FY19Q3 Till date.

 

Also please let me know if the above calculation is different from YTD, QTD REvenue.?

 

PLease let me know if you need a sample data.

 

Appreciate your help this is an immediate requiremt for me.

 

REgards,

Varun

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Q-Q, M-M and Y-Y change if the Financial STARTS from Apr

Hi,

 

I also have months in there now.  See if this works.  Download the PBI file from here.

6 REPLIES 6
Super User
Super User

Re: Q-Q, M-M and Y-Y change if the Financial STARTS from Apr

Hi,

 

Share the link from where your MS Excel file can be downloaded.

Re: Q-Q, M-M and Y-Y change if the Financial STARTS from Apr

Hi Ashish,

 

Thanks for your time, Please fid the sample data.

 

Please let me know if you need further details.

 

image.png

 

REgards,

Varun

Super User
Super User

Re: Q-Q, M-M and Y-Y change if the Financial STARTS from Apr

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png

Re: Q-Q, M-M and Y-Y change if the Financial STARTS from Apr

Hello Ashish,

 

Thanks for your file, could not get the result since i need to get the change every quarter and month.

 

With the same idealogy , tried with my Dataset but still could not get the result.

Appreciate if you could help me.

 

REgards,

Varun

Re: Q-Q, M-M and Y-Y change if the Financial STARTS from Apr

Hi All,

 

Please let me know the solution for the above query.

 

Appreciate your help.

 

REgards,

Varun

Super User
Super User

Re: Q-Q, M-M and Y-Y change if the Financial STARTS from Apr

Hi,

 

I also have months in there now.  See if this works.  Download the PBI file from here.