Forum Discussion
Dealing with Null Values in a Conditional Formula
isblank is used to handle null
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"))))))))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
An error comes back with your solution:
"Token RightParen Expected"
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")))))))))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
