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

Array Format

Hello everyone, good afternoon

I wanted to know if anyone knows how I can reach a format similar to this in a matrix or table.

2023 202
aJanuary FebruaryMarch AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
b
c

I try and he just lets me put the year, but I can't separate them by years.

PVVBl00_0-1689020905639.png

Best regards

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Syndicate_Admin 
You did it right, just need to drill on your columns

Ritaf1983_0-1689045621921.png

Link to a sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

View solution in original post

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Sorry for the delay, yes, ta was solved
Thanks a lot

Ritaf1983
Super User
Super User

Hi @Syndicate_Admin 
You did it right, just need to drill on your columns

Ritaf1983_0-1689045621921.png

Link to a sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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