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
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!!!

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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.