Help with converting IF, ISNUMBER excel funtiotion into Power BI

[Anonymous]

Hello, 

I am trying to create the following formula in power BI.  I try to break it down and try to use it by IF and Switch. I was not able to get the result I want. Can anybody please help me with this? 

Screenshot of excel with the column.

Formular 

=IF(ISNUMBER($K2),$K2-$J2,IF($J2>TODAY(),"",TODAY()-$J2))

Thank you so much

[amitchandak]

@Anonymous , if J is number that it can not be compared with today and if it is then you need to return same type data

try like

Column =
IF(isnumber([Column K]),
[Column K] - [Column J],
IF([Column J] > TODAY(),
blank(),
datediff(TODAY() , [Column J], day)
)
)

[Anonymous]

@amitchandak thank you , Its good to know that I can use excel funtion on power BI, but I am getting an error both my date colunms are formatted to date. Not sure why is that. Any Idea?

Not sure what this is translating to spanish. hopefully you can see it english

[ryan_mayu]

@Anonymous 

please try this

Column = if(ISNUMBER('Table'[record date]),'Table'[record date]-'Table'[date],if('Table'[date]>today(),blank(),today()-'Table'[date]))

[Syndicate_Admin]

@ryan_mayu Thank you, but I am getting error. Please see below if you know anything

[Greg_Deckler · Accepted solution]

@danzidpp

https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991

The DAX functions are identical to the Excel functions in your case, so:

Column = 
  IF(ISNUMBER([Column K]),
    [Column K] - [Column J],
    IF([Column J] > TODAY(),
      "",
      TODAY() - [Column J]
    )
  )

[Anonymous]

@Greg_Deckler  Good to know that I can use excel funtion, but i ma getting an error when I do that. (Both my Due Date and Actual Delivary Date are on Date format). I am not sure what is variant-type cannot be used. Any idea? Thank you 

[Greg_Deckler]

@Anonymous - Yes, you will need to either always return text or numbers. You formula returns text sometimes and numbers other times, that is not allowed in DAX. So you can either replace your "Other" with 0 or some other number.