Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Recreating excel table in power bi

Am lookinbg to able to the 1st date of every month as column titles is there an easy way to do this

Need Help
Show and Tell

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     

    this is an example on what i am trying to recreate

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Anonymous 

    Do you mean that change the "UP to Jan" with "01/12/2017" and so on as column titles.

    If so you just rename it manually.

     

    Best Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      it needs to be rolling month on month, i dont want to have to do this manually as means running the report every month. I want to be able to let it automatically calculate it

      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        hi, Anonymous 

        For rename column titles automatically, I'm afraid it couldn't achieve in Power BI for now.

        column titles are the attribute of table, you need to rename it manually.

         

        Best Regards,

        Lin