Forum Discussion

twister8889's avatar
twister8889
Helper V
4 years ago
Solved

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 table...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

twister8889's avatar
twister8889
Helper V
4 years ago

First of all, thank you for your answer..

Hi Anonymous 

 

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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