Forum Discussion
Power ParticipantDAX IF Statement producing errors highlighted in red font
ArchStanton
Yes sir, if you have got the correct results already then don't worry about it.
Community ChampionArchStanton
What does the error say? Are you sure you are creating a calculated column not a measure?
Power ParticipantI'm still learning PowerBI so please bare with me.
I can't see an error message but In the right hand corner this RED box appears when I go to the end of the code on line 14:
(and the FunctionalArea names are all in Red Font - does that not sugeest a problem)?
This is a new column that will contain only dates that I will use on my visuals.
Hope that makes sense?
- tamerj1
ArchStanton
Two possibilities I can think of. Either you are creating a measure by mistake or you are creating the column in the another table. In order to see the error you need to hit "Enter" and see the error message at the botom of formula box.- ArchStanton
Thanks,
I've hit Enter at the bottom of the Formula Box and nothing happens? Everything is Grey all the way to line 14 but despite this the column has been populated by dates - so could I assume that everything is working and just ignore the red?
Also, the TRUE values such as Assessment, Casework Support etc are the same named values that exist in another table called 'Stage and Area', I'm not sure how that could affect this calculated column as we are in a different table?
Lastly, as this column contains dates that depend on the logical test being TRUE or FALSE, the column was created in the Cases - Active table to compute this. There is no measure icon for this column anywhere.
If you are suggesting this is a measure then should I be seeing this as Meaure in the field bar instead of a Date icon?
Unless I explicitly click on New Measure I cannot see how a measure be created by accident?
Thanks for being patient!
- tamerj1
ArchStanton
Have you tried to restart the power bi desktop application?