Forum Discussion

hemakrishnamoor's avatar
hemakrishnamoor
Frequent Visitor
4 months ago
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...
Need Help
  • hemakrishnamoor's avatar
    hemakrishnamoor
    3 months ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 months ago

Your filter needs to be fed from a disconnected table, cannot be fed directly from the calendar dimension table.

 

 

hemakrishnamoor's avatar
hemakrishnamoor
Frequent Visitor
4 months ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 months ago
    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?

    No.  You need a disconnected table. Your semantic model should also have a calendar table.