Forum Discussion
Help with validating my date formula
gazzo1967 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Greg_Deckler
Apologies 🙂
I will take your point 🙂
So this is what im trying to do.
I am trying to add 24 months to ORACLE_V3[g_ACTIVITY_DATE - Copy] field which will then write to the g_ACTIVITY_DATE_NextDue field ,
NOTE: only the row where the ORACLEV3_ROLE value is 'BA'
All the other rows the ORACLE_V3[g_ACTIVITY_DATE - Copy] field would only add on 12 months to g_ACTIVITY_DATE_NextDue field.
I am using the following formula
g_ACTIVITY_DATE_NextDue = IF(ORACLE_V3[ROLE] = "BA", DATEADD(ORACLE_V3[g_ACTIVITY_DATE - Copy], 24,MONTH), DATEADD(ORACLE_V3[g_ACTIVITY_DATE - Copy], 12,MONTH))
here is the data/ expected outcome
| ORACLEV3_ROLE | ORACLE_V3[g_ACTIVITY_DATE - Copy] | g_ACTIVITY_DATE_NextDue OUTCOME Expected |
| ECO | 12/06/2022 | 12/06/2023 |
| FSG | 13/06/2022 | 13/06/2023 |
| BA | 17/06/2022 | 17/06/2024 |
| FBO | 15/06/2022 | 15/06/2023 |
| EDBA | 16/06/2022 | 16/06/2023 |
| L1 Water | 17/06/2022 | 17/06/2023 |