How to rename field name in a table

[Anonymous]

Hi All,

I need dax expression to rename the below table

MonthYear

July 2017

July 2018

I want to rename July 2017 to YTD 2017 and July 2018 to YTD 2018  to use it on my matrix table.

How can l achieve this in Power BI

[edhans]

Just create a measure called YTD 2017 and have it reference the July 2017 data. Or rename the column manually, or rename it in Power Query, which can change columns.

DAX functions are like Excel functions in that they cannot actually change data, but just calculate it and return results.

[Anonymous]

Hi Ed,

Thanks for your responding, can you show an example of the referencing with the measure.

Thanks

[edhans]

Probably = SUM(tablename[July 2017]) or =SUM(July 2017) if it is a measure itself.

If that isn't right, post sample data so we can see what the underlying data looks like and how July 2017 is being arrived at.