Forum Discussion
Combining 2 Consecutive Measures (Historical and Projected)
The issue was that when the second measure uses the first one as a baseline in a separate table (with dates not connected), it calculates the final value for the first date and then uses that constant as the base for the rest of the measure. However, once you relate the dates to a table to combine them, I no longer get that final constant, and get a blank, as the first measure doesn't calculate as anything for the dates of the second measure.
I fixed this by keeping the historical measure as it was, and changing the projected measure to cover both the historical and projected portion. Then putting the historical as the line on top on the graph, so the only visible portion of the projected line is the actual projections.
The issue was that when the second measure uses the first one as a baseline in a separate table (with dates not connected), it calculates the final value for the first date and then uses that constant as the base for the rest of the measure. However, once you relate the dates to a table to combine them, I no longer get that final constant, and get a blank, as the first measure doesn't calculate as anything for the dates of the second measure.
I fixed this by keeping the historical measure as it was, and changing the projected measure to cover both the historical and projected portion. Then putting the historical as the line on top on the graph, so the only visible portion of the projected line is the actual projections.
