Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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

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/
Anonymous
Not applicable

Hi Ashish,

 

Thanks for your time, Please fid the sample data.

 

Please let me know if you need further details.

 

image.png

 

REgards,

Varun

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/
Anonymous
Not applicable

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

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/
Anonymous
Not applicable

Hi All,

 

Please let me know the solution for the above query.

 

Appreciate your help.

 

REgards,

Varun

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.