Hi Team,
I have two data sources to connect with each other to perform this task.
below is the screenshot for the same:
Need to calculate QTD (exact quarter date of last year to current year comparison) and MTD (2020 m01 to 2021 m01 with the exact date)
Please help me to get the result.
Hi Soumitra could you please help me to get this result.
Regards
Hi Ashish,
Here is the visual I was able to come up with using your dataset.
Here are the formulas for MTD related & QTD related calculations (including % growth)
A) MTD Related
B) QTD Related
I noticed it is missing 10 months of data for 2021. This does cause issues when selecting a Fiscal
Month or Fiscal Quarter from the Parameter list that is from 2020. I think it would be good to add
some dummy data from Mar to Dec 2021. Let me know so I can make the changes and then
upload the twbx file with the updated excel workbook. Take care and Best wishes !
Sincerely,
Soumitra
