Forum Discussion

rpatel-cct's avatar
rpatel-cct
New Member
7 years ago
Solved

AutoFill Blank Cells

Hi All,    Wondering if the following is possible:  In my data set I have 2 columns, Unit and SubUnit.  Within each Unit are multiple SubUnits (ex. Unit 2000 - 2001, 2002, 2003.. as SubUnits).   T...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi rpatel-cct ,

     

    To create a calculated column as below.

    U = IF(ISBLANK('Table'[SubUnit]),'Table'[Unit],'Table'[SubUnit])

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi rpatel-cct ,

 

To create a calculated column as below.

U = IF(ISBLANK('Table'[SubUnit]),'Table'[Unit],'Table'[SubUnit])

 

  • rpatel-cct's avatar
    rpatel-cct
    New Member
    6 years ago

    Thank you so much!