Trouble Joining Time Periods Between Fact Tables

[simonjervis]

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?

[amitchandak · Accepted solution]

@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

[simonjervis]

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. 🙂