Forum Discussion

FZOU's avatar
FZOU
Icon for Helper IV rankHelper IV
5 years ago
Solved

Calculated 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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 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.

FZOU's avatar
FZOU
Icon for Helper IV rankHelper IV
5 years ago

Hi parry2k , i want to create the column named "NEW" based on the column named "OLD" on the picture above !
-If "OLD" begins with A*, then we will have an additional selection as "A" showing all A* . We need to keep each A  as a selection  also !

-to resume i want to get the column with the name "NEW",i hope this could help