Forum Discussion

it_akasjraj's avatar
it_akasjraj
Frequent Visitor
4 years ago
Solved

Add 10 Day In Data Column.

Hi Team and Community Expert's,
I have one date column in my power bi, i have to add 10 days on that column and store value in new column.

 

Description/Example:-

DateDesired Output
04 April 202214 April 2022
08 May 202118 May 2021
09 November 202219 November 2022
10 June 202220 June 2022

 

How To Acheive This By Using DAX? I Tried

Desired_Output = Tablename[Column_Name] + 10 (Not Work)

  • tamerj1's avatar
    tamerj1
    4 years ago

    it_akasjraj 

    So you are creating a new calculated column. Did you try

    Desired_Output = Tablename[Column_Name] +10

9 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi it_akasjraj 
    It should if you are creating a calculated column not a measure.
    However, you can also try

    Desired_Output = DATEADD ( Tablename[Column_Name], +10, DAY)
  • it_akasjraj's avatar
    it_akasjraj
    Frequent Visitor
    4 years ago

    Hello tamerj1 Sir,

    Thanks For Your Sharing.

     

    Sir As Per Your Answer I Have To Create A Calculated Column, Is It Not Possible To Do It Using Measure?

     

    Note: Sir I Am New In Power BI, So Your Explanation Helps Me.

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      it_akasjraj 
      It depends on how your visual look like. In general you may try

      Desired_Output = DATEADD ( MAX ( Tablename[Column_Name] ), +10, DAY)