Forum Discussion
create a dynamic column header based on measures
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 _resultThen use this column as a field of the matrix column.
Best Regards,
Gao
Community Support TeamIf 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
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