Hello, Iv'e run into tough problem I can't figure out on myself. I hope it's possible to solve with PBI.
Let's imagine a table below. For each group I am looking at ID column, and if there is a value different than "#" I am replicating it. If there is only "#" I am leaving it. There is only one ID for each group.
@Anonymous you add a column using following expression
New Col =
VAR __id = CALCULATE( MAX ( 'Table'[Id] ), ALLEXCEPT( 'Table', 'Table'[Group] ) )
VAR __countRowsWithHash = CALCULATE( COUNTROWS ( 'Table' ), ALLEXCEPT( 'Table', 'Table'[Group] ), 'Table'[Id] = "#" )
VAR __countRowsWithoutHash = CALCULATE( COUNTROWS ( 'Table' ), ALLEXCEPT( 'Table', 'Table'[Group] ), 'Table'[Id] <> "#" )
RETURN
IF ( __countRowsWithoutHash == BLANK(), "#", __id )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @Anonymous ,
I have tested @parry2k 's DAX expression and it works well. If you have no other questions, please accept his reply as a solution so that people who may have the same question can get the solution directly.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous you add a column using following expression
New Col =
VAR __id = CALCULATE( MAX ( 'Table'[Id] ), ALLEXCEPT( 'Table', 'Table'[Group] ) )
VAR __countRowsWithHash = CALCULATE( COUNTROWS ( 'Table' ), ALLEXCEPT( 'Table', 'Table'[Group] ), 'Table'[Id] = "#" )
VAR __countRowsWithoutHash = CALCULATE( COUNTROWS ( 'Table' ), ALLEXCEPT( 'Table', 'Table'[Group] ), 'Table'[Id] <> "#" )
RETURN
IF ( __countRowsWithoutHash == BLANK(), "#", __id )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
