Forum Discussion
Merging two lines in a table
Hello, I have a table in Power BI which shows two values (Plan and Forecast) of each month in two different columns and two different lines. This means each line is duplicated, in one case I have the...
Hi bellotma - In Power query editor, you can perform group by function based on item id , month and date as below snapshot.
final output should be look as below:
using the Group By feature and taking the maximum value of Plan and Forecast
Hope it helps, if it is still not resolved.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!