error argument '3' in if function is required

[Anonymous]

Can advice on the error "error argument '3' in if function is required"

Did i missed out anything.

thank you.

Date = 
IF (
AND (
'Mydata'[Date] >= DATE ( 2014, 7, 1 ),
'Mydata'[Date] <= DATE ( 2015, 6, 31 )
),
"FY14",
IF (
AND (
'Mydata'[Date] >= DATE ( 2015, 7, 1 ),
'Mydata'[Date] <= DATE ( 2016, 6, 31 )
),
"FY15",
IF (
AND (
'Mydata'[Date] >= DATE ( 2016, 7, 1 ),
'Mydata'[Date]<= DATE ( 2017, 6, 31 )
),
"FY16",
IF (
AND (
'Mydata'[Date]>= DATE ( 2017, 7 1 ),
'Mydata'[Date] >= DATE ( 2018, 6, 31 )
),
"FY17",
)
)))

[ChrisMendoza · Accepted solution]

---

@Anonymous wrote:

Can advice on the error "error argument '3' in if function is required"

Did i missed out anything.

thank you.

Date = 
IF (
AND (
'Mydata'[Date] >= DATE ( 2014, 7, 1 ),
'Mydata'[Date] <= DATE ( 2015, 6, 31 )
),
"FY14",
IF (
AND (
'Mydata'[Date] >= DATE ( 2015, 7, 1 ),
'Mydata'[Date] <= DATE ( 2016, 6, 31 )
),
"FY15",
IF (
AND (
'Mydata'[Date] >= DATE ( 2016, 7, 1 ),
'Mydata'[Date]<= DATE ( 2017, 6, 31 )
),
"FY16",
IF (
AND (
'Mydata'[Date]>= DATE ( 2017, 7 1 ),
'Mydata'[Date] >= DATE ( 2018, 6, 31 )
),
"FY17", // <- THIS COMMA IS NOT NECESSARY
)
)))

---

Column =
IF (
    AND (
        'Mydata'[Date] >= DATE ( 2014, 7, 1 ),
        'Mydata'[Date] <= DATE ( 2015, 6, 31 )
    ),
    "FY14",
    IF (
        AND (
            'Mydata'[Date] >= DATE ( 2015, 7, 1 ),
            'Mydata'[Date] <= DATE ( 2016, 6, 31 )
        ),
        "FY15",
        IF (
            AND (
                'Mydata'[Date] >= DATE ( 2016, 7, 1 ),
                'Mydata'[Date] <= DATE ( 2017, 6, 31 )
            ),
            "FY16",
            IF (
                AND (
                    'Mydata'[Date] >= DATE ( 2017, 7, 1 ),
                    'Mydata'[Date] >= DATE ( 2018, 6, 31 )
                ),
                "FY17"
            )
        )
    )
)

[Anonymous]

You did solve my problem, Thank you!