Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NB3
Helper III
Helper III

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
ryan_mayu
Super User
Super User

@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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
ryan_mayu
Super User
Super User

@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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

@NB3 

 

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

 

Thanks





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@ryan_mayu

 

It worked after I created a new table,

 

Thanks a lot !

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
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.