Forum Discussion
Beginner question - IF statement
Hey guys, thanks so much for taking the time!
I'm trying my best to get accustomed to DAX and everything but I couldn't seem to get this to work.
I tried the functions you posted but it didn't work. One thing that I don't understand is that some of the fields won't automatically show up when typing the function. For instance, if I type IF(AND([BRAND to get "BRAND_NAME_NEW" to show up, it doesn't. Same goes for other fields, lite date. I'm trying to make a "calls per hour" graph and have tried the "HOUR" function. But when typing HOUR(ORIG for "ORIGINATED_DATE" field (which includes date and time) nothing shows up. I'll post an image to make it clear.
Hope this makes sense!
Anonymous can you post a sample data and expected output? I could return the desired obix to you