Forum Discussion

simonjervis's avatar
simonjervis
New Member
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    simonjervis
    New Member
    4 years ago

    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. ğŸ™‚