Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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", ) )))
Solved! Go to 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" ) ) ) )
Proud to be a Super User!
@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" ) ) ) )
Proud to be a Super User!
You did solve my problem, Thank you!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |