Forum Discussion
Split rows with same id
Hi AMYYC ,
The Power BI visuals don't display duplicate rows. If you want to display all unaggregated rows in the visual, you can add the index column in the Power Query Editor, then close and apply the changes. Then select "Don't summarize" for the fields in the visual.
If you just want to add a column to calculate the value greater than 300 as 2, then you can try the following calculated column.
Column = IF( 'Table'[item inventory] > 300, 2 )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi AMYYC ,
The Power BI visuals don't display duplicate rows. If you want to display all unaggregated rows in the visual, you can add the index column in the Power Query Editor, then close and apply the changes. Then select "Don't summarize" for the fields in the visual.
If you just want to add a column to calculate the value greater than 300 as 2, then you can try the following calculated column.
Column = IF( 'Table'[item inventory] > 300, 2 )
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.