Forum Discussion
Solved
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 t...
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 , 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