Measure name change

[Anonymous]

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.

[Tahreem24]

@Anonymous ,

Simply create one COlumn and write the below logic:

Next Day = Table[DateColumn]+1

[amitchandak]

@Anonymous ,

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

[Anonymous]

@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]

@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]

"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]

@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]

@Anonymous ,

I am also attaching PBIX for your reference.

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

[Anonymous]

@Tahreem24 

Appreciate all the efforts and time taken to rspond back.

However, my requirement is slightly different.

I want the output of the DAX referred in as Name of the field.

please see the image pasted below.