topic Re: Problem with calculated column in DAX Commands and Tips

Problem with calculated column

LevanZukhbaia — Thu, 14 May 2020 20:57:13 GMT

Hi, I am trying to create calculated column so I write this formula

Merge = IF(ISBLANK(Table1[CODE1]) , Table1[CODE2] , Table1[CODE1])

when I tried this formula on small data, it worked, but on big calculated table it does not work (data is 64K rows)

Am I doing something wrong? has anyone encountered such problem?

can you halp me?

VSrujana — Thu, 14 May 2020 21:14:25 GMT

You can create this simple calculated column in Power Query by using "Add conditonal column".
Also please post the error that is showing up in DAX.

Greg_Deckler — Fri, 15 May 2020 04:02:41 GMT

No sure, that seems like pretty tame code. Is there an error or ?

LevanZukhbaia — Mon, 18 May 2020 19:03:55 GMT

There is no error, this formula just return Code 1 column