adding custom column

[Anonymous]

suppose i fetch a month  column from database and have 4 row values .

then i need to add a custom colum with 2 values needed to be repaeat for each rows above..so it will look like below.

Is it possible?

[amitchandak · Accepted solution]

@Anonymous , You need to create a table

generate(distinct(Table[Month/year]) ,

union( Row("Category", "Posted") ,Row("Category", "UnPosted")) )

or

crossjoin(distinct(Table[Month/year]) ,

union( Row("Category", "Posted") ,Row("Category", "UnPosted")) )

[TheoC]

Hi @Anonymous 

I'm sure there is various ways. One way would be to create two custom columns and then Unpivor them in Power Query.

If you use Transform Data to get to Power Query, you cN create a Custom Column and type "Posted" and click okay. Then add another Custom Column that uses "Unposted". Select both new columns and right click the  press Unpivot.  

Hope this helps. Theo