Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

If statement "too few arguments"

Hi all,   I am using power BI for the first time and I am struggling a bit to write an IF function. Idea is very basic, I need to check a cell value (days overdue) and then return a corresponding t...
Need Help
  • tex628's avatar
    tex628
    7 years ago
    AgingBucket =
IF(
[LOOKUP]('As of 6 30 2019'[Days Overdue])<0,"not due",
IF(
[LOOKUP]('As of 6 30 2019'[Days Overdue])<61,"61-90", 
IF(
[LOOKUP]('As of 6 30 2019'[Days Overdue])<61, "61-90",
IF(
[LOOKUP]('As of 6 30 2019'[Days Overdue])<121,"91-120",
IF(
[LOOKUP]('As of 6 30 2019'[Days Overdue])<151,"121-150",
IF(
[LOOKUP]('As of 6 30 2019'[Days Overdue])<181,"151-180",
IF(
[LOOKUP]('As of 6 30 2019'[Days Overdue])<366,"181-365",
IF(
[LOOKUP]('As of 6 30 2019'[Days Overdue])>365,"1+Years" WE NEED ELSE STATEMENT HERE
)))))))))))))

    Missing else on the last IF and missing ")" on a few IF's.


evandrocunico's avatar
evandrocunico
Icon for Resolver III rankResolver III
7 years ago

Hi, look at the last IF...

 

AgingBucket = IF([LOOKUP] ('As of 6 30 2019'[Days Overdue] )<0,"not due",IF([LOOKUP] ('As of 6 30 2019'[Days Overdue] )<61,"61-90", IF([LOOKUP]('As of 6 30 2019'[Days Overdue] )<61, "61-90",IF([LOOKUP]('As of 6 30 2019'[Days Overdue]<121,"91-120",IF([LOOKUP]('As of 6 30 2019'[Days Overdue]<151,"121-150",IF([LOOKUP]('As of 6 30 2019'[Days Overdue]<181,"151-180",IF([LOOKUP]('As of 6 30 2019'[Days Overdue]<366,"181-365",IF([LOOKUP]('As of 6 30 2019'[Days Overdue]>365,"1+Years","second parameter")))))))))))))

 

Regards.

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    You havent closed the lookups. They need to be closed with a ")". Take a look at my previous comment!