Forum Discussion
Issues Occur between Actual and Budget Table
Solution SageCreating a calculated table to use as a dimension on the table you're constructing it from will cause a circular dependency. You need to create the dim in Power Query.
In Power Query, right-click the Account column in Test Sheet, select Add As New Query. Convert this list to table. Repeat this step in BUDGET. Then go to Append Queries > Append as New. Append both these new tables. Remove duplicates from this new Appended table. Rename as you want. Then you'll be able to use this as your account dimension table.
Now when I created the appended table will I also need to include the respective sums
(Test Sheet[Actual Value] and Budget [Budget Value])?
Will I need to create a new relationship between the Test Sheet[Account] and Budget [Account]
to the appended table named Account Dim Table?
Will these be able to sort with a date filter or do I need to include report date to the Account Dim Table?
Thanks!