Forum Discussion

Stefber's avatar
Stefber
Frequent Visitor
11 months 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
    11 months 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
11 months 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
11 months 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