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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Sandeep13
Helper III
Helper III

Create UPPER column in table matrix

Hi All,

 

I want to create new upper column in my table matrix below is screenshot for your reference.

I have data like below and i want to make one upper column name MTD Current Month

 

Below 4 highlighted are measures on top of that want to create MTD Current Month header

Sandeep13_0-1689081391001.png

 

Output column expecting like below 

Sandeep13_2-1689081595362.png

Sharing you some sample data for your reference.

                                MTD Current Month
EnquiryMATCH% MATCHPROJECTED Mnth END EnquiryPROJECTED Mnth END MATCH
                   2                       2100.00%                      3                     3
                   2                       2100.00%                      3                     3
                   1                       1100.00%                      2                     2
       718,290           466,75264.98%       1,197,150         777,920
       428,123           424,44399.14%          713,538         707,405
       393,705           359,46691.30%          656,175         599,110
                  -                        -  0.00%                     -                      -  
       355,824           355,812100.00%       1,067,472         593,020
         40,609             36,76490.53%          121,827           61,273
                  -                        -  0.00%                     -                      -  
           1,788                  38521.53%              5,364             1,155
           3,072               2,66586.75%              9,216             7,995

@Anonymous @Anonymous   @PBICommunity @ExpertBM 

2 REPLIES 2
Sandeep13
Helper III
Helper III

Hi @amitchandak  Thank you for your reply.

But in our organisation we don't use tabular editor. hence I need to find out other way.

 

amitchandak
Super User
Super User

@Sandeep13 , to that you need to create a calculation group and add a calculated colum there with MTD

 

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors