Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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,
Mikkel
Solved! Go to Solution.
HI @tex628
Yes, you're right! I have set my amount values to "sum" instead of "dont summarize". Embassasing but thanks anyhow 🙂
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
HI @tex628
Yes, you're right! I have set my amount values to "sum" instead of "dont summarize". Embassasing but thanks anyhow 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |