cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chandra_0202 Helper V
Helper V

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 IV
Super User IV

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

6 REPLIES 6
Super User IV
Super User IV

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
chandra_0202 Helper V
Helper V

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 IV
Super User IV

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
chandra_0202 Helper V
Helper V

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

chandra_0202 Helper V
Helper V

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 IV
Super User IV

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors