Add 10 Day In Data Column.

[it_akasjraj]

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

Date	Desired Output
04 April 2022	14 April 2022
08 May 2021	18 May 2021
09 November 2022	19 November 2022
10 June 2022	20 June 2022

How To Acheive This By Using DAX? I Tried

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

[it_akasjraj]

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]

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

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

[tamerj1]

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]

@tamerj1 This Is The Error I Got, When I Try To Create The Calculated Column

[tamerj1]

@it_akasjraj 
Can you send a screen shot of your data?

[it_akasjraj]

@tamerj1 Please Find The Screenshot Of Dataset, There Is A Posting Date Column, And My Requirement Is To Make One More Column Beside Positng Date, The Value In New Column Will Be Posting Date + 10 Days...

[tamerj1 · Accepted solution]

@it_akasjraj 

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

Desired_Output = Tablename[Column_Name] +10

[tamerj1]

@it_akasjraj 
You used the code that is for a calculated column. Please see below screenshot.

[tamerj1]

@it_akasjraj