Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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.
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
Thank you! Your solution worked. I had forgotten to accepted it as a solution though.
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!
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.
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
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
189 | |
94 | |
67 | |
63 | |
56 |