Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
10 years ago

Projecting Year by Year

Hi all,   I'm looking to setup an analysis that projects current data forward for the next 10 years. My model has a fact table which is linked to a date dimension table. The date dimension has a gr...
Need Help
Tutorial Requests
SqlJason's avatar
SqlJason
Icon for Memorable Member rankMemorable Member
10 years ago

You can create a new calculated column iin your fact table, which brings in the integer field from the Date table to the fact.

=RELATED(Date[YearIntColumn])

SqlJason's avatar
SqlJason
Icon for Memorable Member rankMemorable Member
10 years ago

Or you can use this formula

MaxYear:=CALCULATE(MAX('Date'[YearInt]), CALCULATETABLE('Fact',ALL('Date'[Year])))

 

I just tested this formula in mine, and it works from what I understood of your requirements.