Forum Discussion
IF Statement Custom Column
Hey,
Trying to create a Custom Column for an IF Calculation, but I keep getting an Error?
Finanical Year = IF ( MONTH (Opportunity[ActualCloseDate]) <4, "0", "1") + Year(Opportunity[ActualCloseDate])
Thanks!
What kind of error are you getting?
There's nothing wrong with this DAX formula (it should work with or without the quotes "0", "1" or 0, 1)
Financial Year = IF ( MONTH ( 'Calendar'[Date] ) < 4, "0", "1" ) + YEAR('Calendar'[Date])Are you maybe doing this in the Query Editor by any chance? There the syntax is different
https://msdn.microsoft.com/en-us/library/mt296606.aspx
Financial Year = (if Date.Month([Date]) < 4 then 0 else 1) + Date.Year([Date])
Hope this helps.
Good Luck! :smileyhappy:
6 Replies
What kind of error are you getting?
There's nothing wrong with this DAX formula (it should work with or without the quotes "0", "1" or 0, 1)
Financial Year = IF ( MONTH ( 'Calendar'[Date] ) < 4, "0", "1" ) + YEAR('Calendar'[Date])Are you maybe doing this in the Query Editor by any chance? There the syntax is different
https://msdn.microsoft.com/en-us/library/mt296606.aspx
Financial Year = (if Date.Month([Date]) < 4 then 0 else 1) + Date.Year([Date])
Hope this helps.
Good Luck! :smileyhappy:
I'm not sure if this is what you're looking for...
Financial Year = if [Date] = null then null else (if Date.Month([Date]) < 4 then 0 else 1) + Date.Year([Date])
Good Luck! :smileyhappy:
Otherwise I suspect MarcelBeug may have something to say! :smileyhappy:
Hi Guys,
I am trying to add a column that will contain if statment in query editor: if column Name contains a word "FALSE" than show me "False" if not show "n/a". At the minute I am getting a token literal error even if I only type =if.
I would be grateful for your help.
