Forum Discussion
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 showing an orderID along with its sequence (SEQ). But here, let say if we filter on "PROCESS = PRO", then we will only be able to see "SEQ" is equal to 6. What I wanted to create is, although we filter on the process column, I will have the MIN sequence.
Below image is my desired table. I only be able to create "MIN SEQ" column. But I don't know how to get "MIN PROCESS" column.
Can someone please advise and show to me how I can work around to get "MIN PROCESS" column? Thanks in advance!
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 👍
1 Reply
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 👍