Forum Discussion
Solved
Dynamic table header with year
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.
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
1 Reply
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