Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

headings in same column as data, need to convert into two columns

    Hi @everyone, I have to split the column "peak lorry movements per month"  taking the subheadings into a new column. How am I supposed to do that?  Thanks in advance.
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    How about trying to create columns like DAX below.

     

    Column1= IF(Table1[Material type]=BALNK(),Table1[peak lorry movements per month],BALNK())

     

    Column2= IF(Table1[Material type]<>BALNK(),Table1[peak lorry movements per month],BALNK())

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

How about trying to create columns like DAX below.

 

Column1= IF(Table1[Material type]=BALNK(),Table1[peak lorry movements per month],BALNK())

 

Column2= IF(Table1[Material type]<>BALNK(),Table1[peak lorry movements per month],BALNK())

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks very much Amy! I thought maybe there was another possibility but yes that makes sense.

Thank youuu v-xicai