cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NB3 Regular Visitor
Regular Visitor

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 way I can have a table with the year and another with YTD (and the dept, associated year and value attached to it) ?

 

And, if someone makes changes in the original document, is it going to refresh afterwards when neeeded ?

 

Thanks for the help,

 

 

Capture.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
ryan_mayu Established Member
Established Member

Re: Split multiple rows and columns

@NB3

 

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

 

c1.JPG

 

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

 

c2.JPG

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

 

c3.JPG

View solution in original post

5 REPLIES 5
ryan_mayu Established Member
Established Member

Re: Split multiple rows and columns

@NB3

 

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

 

c1.JPG

 

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

 

c2.JPG

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

 

c3.JPG

View solution in original post

NB3 Regular Visitor
Regular Visitor

Re: Split multiple rows and columns

@ryan_mayu

 

That's exactly what I need

 

Though I get this message when I try to split in 2 different tables :

 

Capture2.PNG

 

Any idea why ?

 

Thanks a lot,

Community Support Team
Community Support Team

Re: Split multiple rows and columns

Hi @NB3,

 

I think you are use these formula in calculated column, right? if this is a case, ryan_mayu's formula are calculated table formulas, please click on 'new table' icon to create new table to use his formulas.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
ryan_mayu Established Member
Established Member

Re: Split multiple rows and columns

@NB3 

 

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

 

Thanks

NB3 Regular Visitor
Regular Visitor

Re: Split multiple rows and columns

@ryan_mayu

 

It worked after I created a new table,

 

Thanks a lot !

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 337 members 3,193 guests
Please welcome our newest community members: