Forum Discussion
Solved
Help with 5 yr historical data
I have a situation where I am using a published semantic model and so no rights to create a table or add another column. When the user selects a year (there is no date table in this model. Just the y...
Hi,
I have solved it in a different way as my hands were tied with a strict semantic model with no ways of creating a date table or adding a column. Instead of pulling all the 5 years worth historical data together, I had individual measures going after year -1, year -2, etc and solved it. Thank you all for the reply and suggestions. Truly appreciate it.
I just have the one table that has the data in it and the column record create date, which has a hierarchy. The year of that is what the user picks for the report. The matrix below shows yr and yr -5 from the same table. Is that possible?
lbendlin
Super User
Super UserThe year of that is what the user picks for the report. The matrix below shows yr and yr -5 from the same table. Is that possible?No. You need a disconnected table. Your semantic model should also have a calendar table.