March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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!
Solved! Go to Solution.
@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'))
** 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 👍 |
@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'))
** 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 👍 |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
92 | |
91 | |
79 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
72 | |
55 |