Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dealing with Null Values in a Conditional Formula

Hi,   I have a situation dealing with Null Values.  I'm importing a dataset in to Power BI.  One of the columns is DOB and is a numeric number.  In the Edit Query View I transformed the values to D...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

An error comes back with your solution:

 

"Token RightParen Expected"

amitchandak's avatar
amitchandak
Super User
6 years ago
if ([Age] < 10 ,"0-9"
,if ([Age] >= 10 &&[Age] <= 20 ,"10-19"
,if ([Age] >= 20 &&[Age] <= 30 ,"20-29"
,if ([Age] >= 30 &&[Age] <= 40 ,"30-39"
,if ([Age] >= 40 &&[Age] <= 50 ,"40-49"
,if ([Age] >= 50 &&[Age] <= 60 ,"50-59"
,if ([Age] >= 60 &&[Age] <= 65 ,"60-64"
,if ([Age] > 64 ,"65+"
,if (isblank([Age]) , "N/a"
,"N/a")))))))))
  • az38's avatar
    az38
    Community Champion
    6 years ago

    amitchandak 

    it's a DAX

    Anonymous is trying to create a custom column in Power Query Editor

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution