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 outcomeORACLEV3_ROLE ORACLE_V3[g_ACTIVITY_DATE - Copy] g_ACTIVITY_DATE_NextDue
OUTCOME ExpectedECO 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
