Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

error argument '3' in if function is required

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",
)
)))

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar


@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"
            )
        )
    )
)





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar


@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"
            )
        )
    )
)





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Anonymous
Not applicable

You did solve my problem, Thank you!


OSFAMAR_1-1652362434253.png

 

OSFAMAR_2-1652362463524.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.