Forum Discussion
Time Intelligence Function - Do I need a calendar?
Hi Rayyy12 I understand your situation - I am using SAP in the same way :), without Budget functionallity, only actuals. I checked yesterday if there is column in format DD/MM/YYYY is SAP, but no luck. Still, there is posting period (month) and year. Go to your SAP table and "bring" year and month columns into your Excel (except you do not need year). The question arise: how you insert budget into SAP, hope not manually so somewhere you already have date7s columns?
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.
