Forum Discussion
Trouble Joining Time Periods Between Fact Tables
I have 3 fact tables ('Budget', '3+9' and 'Actual') that each contain values by 'Period'.
I have created a measure to calculate the cumulative sum of values by period in each table, and they are working fine.
BUT... when I try and put them both onto the same chart, whichever one I don't have the 'Period' field dragged into Axis just shows the grand total (not a cumulative by period).
I have no link between the periods in my three fact tables. Does anyone have any advice on how I can resolve?
simonjervis , Hope period is coming from a common table on axis as well as in measure formula
example using a date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
all cumulative measure should use common period table
2 Replies
- amitchandak
Super User
simonjervis , Hope period is coming from a common table on axis as well as in measure formula
example using a date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
all cumulative measure should use common period table
Thank you @amitchandak I created a table that contained period number, and used it to link the 3 fact tables, and as you suggested, referenced this period field in all cumulative calculations and the chart itself. Thank you for your help! I had been going round in circles for hours. 🙂
