Forum Discussion

karthiknpm's avatar
karthiknpm
Regular Visitor
8 years ago
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.
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    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

     

     

TomMartens's avatar
TomMartens
Super User
8 years ago

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