The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Output column expecting like below
Sharing you some sample data for your reference.
MTD Current Month | ||||
Enquiry | MATCH | % MATCH | PROJECTED Mnth END Enquiry | PROJECTED Mnth END MATCH |
2 | 2 | 100.00% | 3 | 3 |
2 | 2 | 100.00% | 3 | 3 |
1 | 1 | 100.00% | 2 | 2 |
718,290 | 466,752 | 64.98% | 1,197,150 | 777,920 |
428,123 | 424,443 | 99.14% | 713,538 | 707,405 |
393,705 | 359,466 | 91.30% | 656,175 | 599,110 |
- | - | 0.00% | - | - |
355,824 | 355,812 | 100.00% | 1,067,472 | 593,020 |
40,609 | 36,764 | 90.53% | 121,827 | 61,273 |
- | - | 0.00% | - | - |
1,788 | 385 | 21.53% | 5,364 | 1,155 |
3,072 | 2,665 | 86.75% | 9,216 | 7,995 |
@Anonymous @Anonymous @PBICommunity @ExpertBM
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.
@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