Forum Discussion
Measure name change
Anonymous ,
something like this format(eomonth(today(),-1)+1,"dd-mm-yyyy")
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.?
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.
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!!!
"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.
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.
