Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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.
Works like a charm, I really appreciate your help 🙂
Now I just need to understand it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |