Display the actual number of current and next week as columns? (dynamic column name)

[ovonel]

I have 2 measures working fine, where I display some data for this week and next week…

Measures this week and next week:

var WW = calculate(min('DimDate'[WeekYearWeekNumber]),

                      filter('DimDate',  'DimDate'[Date] = today() )

                       )

RETURN

CALCULATE([measure],  'DimDate'[WeekYearWeekNumber]=Nextw)

var WW = calculate(min('DimDate'[WeekYearWeekNumber]),

                      filter('DimDate',  'DimDate'[Date] = today()+7 )

                       )

RETURN

CALCULATE([measure], 'DimDate'[WeekYearWeekNumber]=Nextw)

I am displaying the above; as 2 columns in a table fine… But of course the name of the measures are static… I would like to display the actual number of current week and next week, how can I achieve dynamic column names?

[v-yiruan-msft]

Hi @ovonel ,

Could you please provide some raw data in your tables (exclude sensitive data) with Text format, the formula of [measure] and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards