I'm wondering if there is a smarter way of doing what I'm doing. Here is how I do it today.

[925stuart]

Hi all!  I'm wondering if there is a smarter way of doing what I'm doing.  Here is how I do it today.

1. I've a raw data of Born Date. 
2. I then create a new column named Age where Age = Today() minus Born Date.
3. I then create more columns like so,
   1. Is_Teen = Below 18 years old.
   2. Is_YoungAdult = ........
   3. So and and so forth.

I create the columns Is_Teen, Is_YoungAdult, etc... so that I can plot a column chart showing age spread.  Is there a simpler way to do this without creating all those columns like Is_Teen, Is_YoungAdult, etc?

Thanks!

[Ashish_Mathur]

Hi,

You should not create multiple columns.  Just create a single column and in that, via an IF() function, generate th results as Teen, Young adult etc.

[925stuart · Accepted solution]

Thanks!  I think I found the answer here: Power BI: Use DAX Switch Function to Make IF Functions Easier - YouTube