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.
I have treid in vain to create a new table that only has some of the rows in the original and would appreciate some help.
I have a table called 'Stuff'. It has many columns and a lot of rows. I want to create a new table called 'SomeStuff' that only has the rows who's column 'strategies' contains the phrase 'Technology-'.
I have tried using CONTAINS and IF and FILTER and have no success.
The corrext DAX would be greatly appreciated.
Solved! Go to Solution.
Hi @TPB_Paul
You can create a new Calculated Table as follows
Go to Modelling Tab>> New Table
New Table = FILTER ( ADDCOLUMNS ( stuff, "Check", FIND ( "Technology-", Stuff[Strategies],, 0 ) ), [Check] > 0 )
Also you can add a calculated Column and filter the results using this column
Column = FIND ( "Technology-", Stuff[Strategies],, 0 )
Hi @TPB_Paul
You can create a new Calculated Table as follows
Go to Modelling Tab>> New Table
New Table = FILTER ( ADDCOLUMNS ( stuff, "Check", FIND ( "Technology-", Stuff[Strategies],, 0 ) ), [Check] > 0 )
Also you can add a calculated Column and filter the results using this column
Column = FIND ( "Technology-", Stuff[Strategies],, 0 )
This was a great help for usin g the FIND. However my main problem is the fact that PowerBI does not save the settings for a filter and I need that functionality so that each department only sees their data. If I could combine FIND and FILTER I could solve the problem. If I have a column named DEPT, and out of all the departments I want to filter 'SPORTS', is there a way I could create a column that would act as a filter to only show data for the SPORTS department?
This would solve all my filtering problems until there is a way to save default filtering in a report.
Worked great. Thanks so much !!
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |