Forum Discussion

MichaelHutchens's avatar
MichaelHutchens
Icon for Helper V rankHelper V
5 years ago
Solved

Calculated column to account for column blanks

Hi folks, I have a simple table with 'Author' and 'Created By' fields. I'd like to create a calculated column with the logic that:   "If 'Author' is blank, then copy 'Created By' field to 'NewColum...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi MichaelHutchens 

    To create a Calculated Column in DAX use this

    Column = IF(ISBLANK([Author]), [Created By], [Author])

     Regards

    Phil