Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I am trying to create a relationship/comparison between budgeted and actual amounts in Excel/Power Pivot with Odata from Budget (Page 120 G/L Budget Entries) and General ledger (Page 20 General Ledger Entries) for G/L Account No, Global dimension 1 and Date. However, when importing the above pages in Power Pivot I don't know how to create the relationship for Budget vs Actual for a specific account no, global dimension and date, as in the picture below - General Ledger and Budget appear as separate "sources" when i'm creating the Pivot Table and thus they cannot be compared
I have also done an import of page DimensionSetEntries and Chart of Accounts. Do any of you know how I can create a relationship and compare Actual Amount with Budgeted amount from the above Odata-pages in PowerPivot?
I am also interested in this topic.
I am using Power BI , and have gathered Data using Power Query from Dynamics 365 Business Central.
I have tables:
Accounts, General Ledger Entries, Budget Entries, Dimensions (Cost centers), DimTable
But also unsure how to relate, i did not find anything.One option / direction is to create a new Dax table with comparison, like:
ActualsVsBudget = FILTER(
"Account", 'G/L Entries'[Bal Account No],
"Posting Date", 'G/L Entries'[Posting Date],
"ActualAmount", -1*'G/L Entries'[Amount],
"ActualCostCenter", 'G/L Entries'[Global Dimension 1 Code],
"Actual Description", 'G/L Entries'[Description]
SELECTCOLUMNS('G/L Budget Entries',
"Budget Account", 'G/L Budget Entries'[G/L Account No],
"Budget Date", 'G/L Budget Entries'[Date],
"BudgetAmount", 'G/L Budget Entries'[BudgetAmount],
"BudgetCostCenter", 'G/L Budget Entries'[Global Dimension 1 Code],
"Budget Description", 'G/L Budget Entries'[Description]
[Account] = [Budget Account] &&
([ActualCostCenter] = [BudgetCostCenter] || [BudgetCostCenter] = "" || [ActualCostCenter] = "")
Business Applications communities