Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Need you expert advice i want to create 2 columns within table using filter function. Below is how my data look.
Column A include both home & design types & column B can be used for filter. Now i want that based on column B i can put all home types under home & Design types under design column.
Regards
@Gaurav_84 , new columns
Column B = Switch( True() ,
search("Home",[ColumnA],,0) > 0 , "Home ",
search("Design",[ColumnA],,0) > 0 , "Design", Blank() )
Home = if([Column b] ="Home", "Home", blank())
Design= if([Column b] ="Design", "Home", blank())
Hi Amit, Thanks for your response, i believe i have given the incorrect example. Right example should be like below one.
@Gaurav_84 , I think First switch has to change
example
Column B = Switch( True() ,
[Column A] in {"Value1", "Value2", "ABC",
//add others
search("Design",[ColumnA],,0) > 0 , "Design", Blank() )
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thanks Amit, I got bit confused can you please explain the query you have written with below data example.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |