if statement Plus Count

[Anonymous]

I have two columns:

Actual Planned   CountTheRow

P1                   10        2              1
P2               6         10                1
P3               5                            1
P4                            12            1

I would normally use something like this:

if(isnum(Actual),1,if(isnum(Planned),1))

So if P1 has either a Planned or an Actual amount - the row is counted, 

Also: wh is it so hard to type into this section?  Tab and returns are odd???
Jo

[pranit828]

Hi @Anonymous 

You could do

IF( NOT( ISBLANK( [Actual] ) ) || NOT( ISBLANK( [Planned] ) ) ,1 ,0)

[Anonymous]

Thank you - this is very strange - I am translated into Spanish? And I cannot press tab or enter ... I think it is because I am the opposite part of the globe?

Already

[amitchandak]

@Anonymous , you will get both the English and Spanish messages. just check the correct ticket in your profile.

[Anonymous]

I think I need lessons on how to use this interface ... let alone power BI!
-

[v-easonf-msft]

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.

Best Regards,
Community Support Team _ Eason

[pranit828]

Hi @Anonymous ,

Every post here is translated from english to spanish and vis-a-varsa.

Your post is also in english. Click the icon 

on top right of this window you will see both posts. Right now there is no way to switch of spanish.

[amitchandak]

@Anonymous , Create a new column like

if(not(isblank([Actual])) || not(isblank([Planned])),1,0)