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

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
1 year ago

Hello Stefber 

 

Not 100% sure about your request. Would 'Upvioting' give you the table format you want? 

If so, in your Power Query, right click 'ID column' and then click 'Unpivot Other Columns'. 

Rename 'Attribute' to Fiscal Year and i assume now you would be able to filter by fiscal year?