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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Parvathi
New Member

Dynamic Week updation for the measure

Parvathi_0-1666969553518.png

Hello Everyone,

I have my data which is dynamically updating Week by Week with the measure but I want change my Column header dynamically. Could you please help.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

im not sure if i understood but if dates are automatically added every week,simply create a week nb column by naming it week = "W " & Weeknum(table[date],1) and then adding this column to the column matrix

if this helps, kindly accept as solution and a kudos is appreciated

View solution in original post

1 REPLY 1
Anonymous
Not applicable

im not sure if i understood but if dates are automatically added every week,simply create a week nb column by naming it week = "W " & Weeknum(table[date],1) and then adding this column to the column matrix

if this helps, kindly accept as solution and a kudos is appreciated

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors