Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 |
Solved! Go to 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
@twister8889 , Not very clear .
A new column
COlumn = "/"
or
Column = blank()
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
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
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |