Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi,
I also have months in there now. See if this works. Download the PBI file from here.
Hi,
Share the link from where your MS Excel file can be downloaded.
Hi Ashish,
Thanks for your time, Please fid the sample data.
Please let me know if you need further details.
REgards,
Varun
Hi,
You may download my PBI file from here.
Hope this helps.
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.
Hi All,
Please let me know the solution for the above query.
Appreciate your help.
REgards,
Varun
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |