Forum Discussion
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...
Thats what I tried but it keeps on spitting out the same value for all the results (the maximum number in the dimension table).
Edit, resolved that issue by adding a numeric year column to the fact table
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])
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.