Forum Discussion
DAX IF Statement producing errors highlighted in red font
- 4 years ago
ArchStanton
Yes sir, if you have got the correct results already then don't worry about it.
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!
ArchStanton
Have you tried to restart the power bi desktop application?
- ArchStanton4 years ago
Power Participant
Yes and the red bar is still there.
Like I said previously, the dates have been populated in that column, although there are about a 1,000 empty cells. Maybe I should just ignore it
- tamerj14 years ago
Community Champion
ArchStanton
Yes sir, if you have got the correct results already then don't worry about it.