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

amitchandak's avatar
amitchandak
Super User
4 years ago

twister8889 , Not very clear .

 

A new column

 

COlumn = "/"

 

or

 

Column = blank()

twister8889's avatar
twister8889
Helper V
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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'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