I have build the Business Central datamodel in Power BI and want to look at the amount from G_LEntries table split on month from my calender table. However it returns a blank value:
When I add "No" from CS_GLAcoounts table it is possible:
My datamodel using "No" from CS_GLAccounts and "G_L_Account_Name" from G_LEntries as key
Can you help? Best regards,
Go to Solution.
Yes, you're right! I have set my amount values to "sum" instead of "dont summarize". Embassasing but thanks anyhow 🙂
View solution in original post
From what i can tell the total sum of all transactions across your accounts is 0.
If you scroll down in your second table with the account breakdown, what is the grand total showing you per month? Br,J
Ahhh well good to hear it worked out! 🙂
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.