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
    10 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

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi Stefber,

 

Just following up to see if the Response provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking perticular response as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

 

Best 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
      10 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