Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How can I create a NEW table with :
Name | Status | Date |
A | S1 | 1/1/2018 |
A | S2 | 1/15/2018 |
A | S3 | 3/7/2018 |
B | S1 | 2/3/2018 |
B | S2 | 4/2/2018 |
C | S1 | 6/1/2018 |
How can I remove all the rows containing the status of "S3"? The O/P should be (in a new table as I want to retain both) :-
Name | Status | Date |
B | S1 | 2/3/2018 |
B | S2 | 4/2/2018 |
C | S1 | 6/1/2018 |
Solved! Go to Solution.
@Anonymous following dax for new table
New Table =
CALULATETABLE ( YourTableName, YourTableName[Status] <> "S3" )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
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 ,
You can create a new Table.
Table 2 =
VAR a =
CALCULATETABLE (
VALUES ( 'Table'[Name] ),
'Table'[Status] = "S3"
)
VAR b =
VALUES ( 'Table'[Name] )
VAR c =
EXCEPT (
b,
a
)
RETURN
CALCULATETABLE (
'Table',
'Table'[Name]
IN c
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@Anonymous , This might have been resolved already by the last two updates. Posting As I created a file in between. Please find the file after the signature.
Hi @Anonymous ,
You can create a new Table.
Table 2 =
VAR a =
CALCULATETABLE (
VALUES ( 'Table'[Name] ),
'Table'[Status] = "S3"
)
VAR b =
VALUES ( 'Table'[Name] )
VAR c =
EXCEPT (
b,
a
)
RETURN
CALCULATETABLE (
'Table',
'Table'[Name]
IN c
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@Anonymous following dax for new table
New Table =
CALULATETABLE ( YourTableName, YourTableName[Status] <> "S3" )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
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 @parry2k ,
This will remove the Status of "S3". However, I want to remove all the names that have the status of "S3". In our example, since Name - A has S3 status, it should not populate at all.
@Anonymous , This might have been resolved already by the last two updates. Posting As I created a file in between. Please find the file after the signature.
@Anonymous got it, try this
Table 2 =
VAR __table = CALCULATETABLE ( VALUES ( Data[Name] ), Data[Status] = "S3" )
RETURN CALCULATETABLE ( Data, EXCEPT ( VALUES ( Data[Name] ), __table ) )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
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.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |