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...
Need Help
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!!!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    "Next day" should be dynamic and should anchor the output of the DAX i.e.

    say Today's date = June 9th

    Next day = today()+1 = June 10th.

    June 10th should be name of the field not Next day.

    Kind of circular referencing.

     

    Any more ideas please.

     

    • Tahreem24's avatar
      Tahreem24
      Super User
      6 years ago

      Anonymous ,

      Like as I mentioned in my prevoius post:

      Next Day = Today()+1

      Next Day 2 = EOMONTH(Today(),1)

       

      Try these two method in new column.

       

      • Tahreem24's avatar
        Tahreem24
        Super User
        6 years ago

        Anonymous ,

        I am also attaching PBIX for your reference.

        I would really appreaciate your KUDOS/THUMBS UP for your support!!!