Forum Discussion
Time Intelligence Function - Do I need a calendar?
Hi, I am a bit confused if I would require a calendar for my data analysis. I viewed a post similar to my question but it did not give the answer I needed. My data is extracted from SAP to MS Exc...
some_bih Yes, I agree. Currently my dataset looks exactly like the example above (only the countries and products are missing), so my budget is extracted from SAP where I also get my actuals and prior year values. So I'm figuring out how I can calculate the year to date for each of these 3 criterias to make a good comparison. I hope that explains it.
Hi Rayyy12 from my experience use details as much as possible on both side (actual and budget) as it is easier to summarize higher level than allocate sum to part whatever logic is in place. I am writing this before you go to some solution in Excel / Power BI and make sure your stakeholders are aware your inputs concerning granularity of data.