Create blank column to divide values into matrix table

[twister8889]

Hi guys, 

I have a dataset that contains, current values (past and present month) and the forecast month, these information are divided by a column flag Current/Future. I created two matrix tables, and for each, I choose a flag Current/Future, but I would like just one table, and insert a blank column to divide the values Current and Future, it's possible?

This is my

Product	Month	Current/Future	Values
A	ago	1	10
B	ago	1	5
C	ago	1	2
D	ago	1	4
A	set	1	2
B	set	1	4
C	set	1	5
D	set	1	6
A	out	2	50
B	out	2	60
C	out	2	45
D	out	2	20

Expected result: Insert the blank column to separate Current and futere values.

Product	ago	set		out
A	10	2		50
B	5	4		60
C	2	5		45
D	4	6		20

[amitchandak]

@twister8889 , Not very clear .

A new column

COlumn = "/"

or

Column = blank()

[twister8889]

First of all, thank you for your answer..

I have a measure for example Sum(Values), for month columns (Aug, September) with the flag 1 and the same measure for october is 2.
So, I would like to insert the blank column between end flags with value 1 and begin
flag value 2

[v-yiruan-msft]

Hi @twister8889 ,

I created a sample pbix file(see attachment), please check whether that is what you want.

If the above one is not your expected result, please provide more details(include calculation logic and expected result with screenshot) on your requirement. Thank you.

Best Regards

[twister8889]

First of all, thank you for your answer..

Hi @v-yiruan-msft 

I need to have just one column with logical to Current and Future Values, and I need to put one blank column to separate Current and Futures Values, like the image below

[v-yiruan-msft · Accepted solution]

Hi @twister8889 ,

I updated my sample pbix file(see attachment), please check whether that is what you want.

1. Pivot: use the names in column "Month" to create new columns (Values: Values column) in Power Query Editor

2. Add custom column in Power Query Editor

3. Create visual as shown in the below screenshot

Best Regards