topic Add 10 Day In Data Column. in DAX Commands and Tips

Add 10 Day In Data Column.

it_akasjraj — Thu, 14 Apr 2022 10:01:50 GMT

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)

Re: Add 10 Day In Data Column.

tamerj1 — Thu, 14 Apr 2022 10:17:02 GMT

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)

Re: Add 10 Day In Data Column.

it_akasjraj — Fri, 15 Apr 2022 04:46:27 GMT

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.

Re: Add 10 Day In Data Column.

tamerj1 — Fri, 15 Apr 2022 05:14:10 GMT

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

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

Re: Add 10 Day In Data Column.

it_akasjraj — Fri, 15 Apr 2022 07:42:44 GMT

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

Re: Add 10 Day In Data Column.

tamerj1 — Fri, 15 Apr 2022 07:48:57 GMT

it_akasjraj

Re: Add 10 Day In Data Column.

tamerj1 — Fri, 15 Apr 2022 07:50:40 GMT

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

Re: Add 10 Day In Data Column.

tamerj1 — Fri, 15 Apr 2022 07:56:38 GMT

it_akasjraj
Can you send a screen shot of your data?

Re: Add 10 Day In Data Column.

it_akasjraj — Mon, 18 Apr 2022 04:52:57 GMT

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

Re: Add 10 Day In Data Column.

tamerj1 — Mon, 18 Apr 2022 06:50:11 GMT

it_akasjraj

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

Desired_Output = Tablename[Column_Name] +10