Forum Discussion
Create blank column to divide values into matrix table
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 |
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
5 Replies
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 2Hi 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
