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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rainchong7401
Helper III
Helper III

How to arrange year and column name properly

Hi Friends,
Do you guys have any idea how to arrange the column 
Make it as expected output down below.

Expected output:
2021  2022  2021  2022
A        A        B       B

image.pngUntitled.pngUntitled2.png

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @rainchong7401 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

 

Best Regards,

Community Support Team _Tang

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

v-xiaotang
Community Support
Community Support

Hi @rainchong7401 

You have to put A&B column firstly, 

for example,
A        A       |   B        B

2021  2022  |   2021   2022

 

 

Best Regards,

Community Support Team _Tang

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

amitchandak
Super User
Super User

@rainchong7401 , You measure above year, You need a calculation group for that

 

I have discussed few formats here

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.