Solved: Problem with calculated column

LevanZukhbaia · ‎05-14-2020

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 · ‎05-14-2020

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 · ‎05-14-2020

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

LevanZukhbaia · ‎05-18-2020

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

VSrujana · ‎05-14-2020

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.

Problem with calculated column