Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
So you are creating a new calculated column. Did you try
Desired_Output = Tablename[Column_Name] +10
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.
@it_akasjraj
It depends on how your visual look like. In general you may try
Desired_Output = DATEADD ( MAX ( Tablename[Column_Name] ), +10, DAY)
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)
@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...
So you are creating a new calculated column. Did you try
Desired_Output = Tablename[Column_Name] +10
@it_akasjraj
You used the code that is for a calculated column. Please see below screenshot.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |