Forum Discussion
FZOU
Helper IV
5 years agoCalculated Column
Hi everyone, I want to create a column named "NEW" from column "OLD" like the picture below! the rules are to take same values from OLD to NEW but with adding new values that group -If "OLD" begi...
- Anonymous5 years ago
Hi FZOU ,
According to my undertanding, you want to display all rows beginning with the first letter of the selected value in slicer, right?
As mentioned above, after creating a new table, please try the following measure:
Measure = IF ( LEFT ( MAX ( 'Table'[OLD] ), 1 ) = LEFT ( SELECTEDVALUE ( 'New Table'[New] ), 1 ), 1, 0 )And apply it to visual-filter pane, set as "=1" like this:
Here is the pbix file.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.