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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Jeanxyz
Impactful Individual
Impactful Individual

create a dynamic column header based on measures

I have created a timesheet matrix table as below. the current column field is Intl week number (e.g., 13, 14,15...). I need to populate the start date of each week into the column header, something like "week14 - 4/4/2022". Is there a way to populate this value to the column header. 

It's easy to populate this data in a table, but I have to use a matrix table here, hence there is an issue. 

timesheet header.PNG

1 ACCEPTED SOLUTION

Hi @Jeanxyz ,

 

Please create a calculated column in the calendar table.

 

Week_Date = 
VAR _weeknum =
    WEEKNUM ( 'Calendar'[Date], 2 )
VAR _firstdate =
    CALCULATE (
        MIN ( 'Calendar'[Date] ),
        FILTER ( ALL ( 'Calendar'[Date] ), WEEKNUM ( 'Calendar'[Date], 2 ) = _weeknum )
    )
VAR _result = "Week" & _weeknum & "-" & _firstdate
RETURN
    _result

 

Then use this column as a field of the matrix column.

vcgaomsft_1-1655979324837.png

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

View solution in original post

4 REPLIES 4
Jeanxyz
Impactful Individual
Impactful Individual

Thank you! Your solution worked. I had forgotten to accepted it as a solution though. 

mh2587
Super User
Super User

Week Start Date/Wk No = CONCATENATE(Data[Date] – WEEKDAY(Data[Date],2) + 1,Intl week number)
//try this one


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Jeanxyz
Impactful Individual
Impactful Individual

The thing is I can't drag a measure into the column field. I have create a tooltip page to show weekstart data. Maybe someone has a better solution. 

Hi @Jeanxyz ,

 

Please create a calculated column in the calendar table.

 

Week_Date = 
VAR _weeknum =
    WEEKNUM ( 'Calendar'[Date], 2 )
VAR _firstdate =
    CALCULATE (
        MIN ( 'Calendar'[Date] ),
        FILTER ( ALL ( 'Calendar'[Date] ), WEEKNUM ( 'Calendar'[Date], 2 ) = _weeknum )
    )
VAR _result = "Week" & _weeknum & "-" & _firstdate
RETURN
    _result

 

Then use this column as a field of the matrix column.

vcgaomsft_1-1655979324837.png

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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