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...
Hi Rayyy12 to do analysis in Power BI by date you will need Date table. Nevertheless, if you have possibilities to connect SAP and Power BI maybe best alternative to you. Check link https://learn.microsoft.com/en-us/power-query/connectors/sap-bw/message-setup-and-connect Hope this help
Hi some_bih thank you for your answer. Since I don't have a date column (DD/MM/YYYY), would my date table be different? I would appreciate some advice on this. The only date indicator in my dataset would be the months as mentioned above.
Moreover, due to certain difficulties I won't be able to connect to SAP directly (though I wish I could but it's not in my control). So that leaves me with the only option of extracting it to Excel and then to Power BI.