Dynamic table header with year

[karthiknpm]

Hi Team,

I would like to design a table in Power bi report which will have dynamic column header with years.

How to get dynamic year using power query.

Year(Today()) - shows error.

[TomMartens · Accepted solution]

Hey,

you can use this PowerQuery function to get the Year-part from the Today-Date:

Date.Year(DateTime.LocalNow())

Hopefully this gets you started

Regards

Tom