Forum Discussion

New_be's avatar
New_be
Helper V
4 years ago
Solved

Return String Column by valuating numbers column

Hi expert,   Problem: I have a problem with one of my report. I try to return/create a column for string by valuating a number column. Below I have an example.   Scenario: Left image are showin...
Need Help
Show and Tell
Tips and Tricks
  • ghoshabhijeet's avatar
    ghoshabhijeet
    4 years ago

    New_be  Thanks for sharing your query.

     

    Here is my solution. Please try this.

    Create the following two measures and use it on your table:

     

    Min SEQ = CALCULATE(MIN('DataTable'[SEQ]), REMOVEFILTERS('DataTable'))
    Min PROCESS = 

    VAR MinSEQ = [Min SEQ]

    RETURN

    CALCULATE(MIN('DataTable'[PROCESS]), 'DataTable'[SEQ] = MinSEQ, REMOVEFILTERS('DataTable'))
     
    Here is the result:

     

    ** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

    Good Luck 👍

     

ghoshabhijeet's avatar
ghoshabhijeet
Solution Supplier
4 years ago

New_be  Thanks for sharing your query.

 

Here is my solution. Please try this.

Create the following two measures and use it on your table:

 

Min SEQ = CALCULATE(MIN('DataTable'[SEQ]), REMOVEFILTERS('DataTable'))
Min PROCESS = 

VAR MinSEQ = [Min SEQ]

RETURN

CALCULATE(MIN('DataTable'[PROCESS]), 'DataTable'[SEQ] = MinSEQ, REMOVEFILTERS('DataTable'))
 
Here is the result:

 

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍