Forum Discussion

Stefber's avatar
Stefber
Frequent Visitor
1 year ago
Solved

Modeling Solution?

I have a data file that I need to be able to filter by Fiscal Year.  The information is sorted into columns like below.  Any suggestions?   ID Current FY Prior FY Prior FY  2 Prior FY 3 1...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Stefber,

     

    Thanks for the update. Glad to hear the unpivot tip helped and you were able to restructure your data! Just checking does this mean your issue is fully resolved?

     

    Thanks & Regards,

    Prasanna Kumar

Stefber's avatar
Stefber
Frequent Visitor
1 year ago

Prasanna Kumar, It was helpful thank you! It is a lage, flat data set that included many more comuns, so I separated it into three tables- not as elegant as I'd like, but the unpivot tip worked for what I needed. Thank you!

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Stefber,

 

Thanks for the update. Glad to hear the unpivot tip helped and you were able to restructure your data! Just checking does this mean your issue is fully resolved?

 

Thanks & Regards,

Prasanna Kumar