Sage 200 Integration

[Chris2B]

Hi I need some help with Sage 200 Integration. I feel that it has pulled in too many tables. I have tried to make a calendar table, but it has gone all the way to 1818 instead of the begining of my records which should be 2018. This has meant that I have not been able to use any time intelligance DAX as I have had to use last 6periods and Last 6 periods last year. This has been very frustrating for me as I would prefer to use a calendar table with financial year and also be able to filter through each financial year as opposed to just the last financial year. Any help would be amazing!  This would also help because it has also given me an automatic measure of PY Sales and CY Sales, which does not help me.

Kind Regards,

Chris

[Anonymous]

Hi @Chris2B ,

Thanks for reaching out to us with your problem. Base on your description, it seems that you are trying to create a custom calendar table with financial data. And you want to create a PY sales and CY sales. Could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards