Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure name change

Hello PBI Users,

 

I am looking for help in automation of a measure name/calculation.

 

Every month when data gets added i want the calculation to automatically add +1 month to the existing field name.

say if name of the field reads 06-01-2020 (mm-dd-yyyy), then this should be autochanged to 07-01-2020 when the report is opened in july.

 

Thanks.

Need Help

8 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Anonymous ,

    Simply create one COlumn and write the below logic:

    Next Day = Table[DateColumn]+1

     

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous ,

    something like this format(eomonth(today(),-1)+1,"dd-mm-yyyy")

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak 

      Thanks for your response.

      I get below error when i tried your approach.

      and by adding a field name DAX turns blue and valid. However, the purpose of this formulae is not fulfilled which is dynamic naming based on current date. Do you have any other suggestions/workarounds please.?

       

      Tahreem24 

      Thank Q for your response.

      Unfortunately, i dont have date fields in my data that i can add/subtract #days/weeks/months.

      Objective is to create a date value as field name based on current month or next month etc.

       

      Please let me know, if there are any other ways to acheive this.

      Will be really helpful.

      • Tahreem24's avatar
        Tahreem24
        Super User
        6 years ago

        Anonymous ,

        Kindly try given logic:

        If you have any date column in your model so use the below Logic in new Column:

        Next Day = TableName[DateColumn]+1

        Or if you want today's date so use the below logic :

        Next Day = Today()+1

         

        Kindly hit on Thumbs up for your support!!!