Forum Discussion

NB3's avatar
NB3
Helper III
7 years ago
Solved

Split multiple rows and columns

Hi everyone,   I need to create 2 different charts based on the following table (on with the year and one with YTD).   In the document it is from, year and YTD are mixed together ... Is there any...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    7 years ago

    NB3

     

    I will create two tables for this. Please check if this can meet your requirements. Thanks

     

     

    TABLE2 = FILTER('Sheet27',SEARCH("YTD",'Sheet27'[Year],1,0)=0)

     

    TABLE3 = FILTER('Sheet27',SEARCH("YTD",'Sheet27'[Year],1,0)>0)

     

ryan_mayu's avatar
ryan_mayu
Super User
7 years ago

NB3 

 

Are you creating a new table or new measure? This coding has to be used when you creating  a new table.

 

Thanks

NB3's avatar
NB3
Helper III
7 years ago

ryan_mayu

 

It worked after I created a new table,

 

Thanks a lot !