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.

v-moharafi-msft's avatar
v-moharafi-msft
Icon for Community Support rankCommunity Support
4 months ago

Hi  hemakrishnamoor ,


Thank you for reaching out to Microsoft Fabric Community and Thanks to lbendlin   , @danextian  and cengizhanarslan   for Sharing valuable insights.


Just wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

 

 Best Regards,

Abdul Rafi.