@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!
