Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey guys!
I need to determine the max value for a specific case.
I have a simple sales table that contains some basic information per order with these columns:
This table contains 1 row per order
Then I have a second table that is linked to this table using the Order-Nr and contains some more information:
This table shows me the routing per order and contains several rows per order.
Now I would like to add a calculated column into the first table that contains the Max Status for each order and the corresponding step name. The first table already has the latest Step name per Order. I just need to add the latest Status for the order and the latest Step Name
@joshua1990 , Try a new column in Table 1
maxx(filter(Table2, Table2[Order-Nr] = Table1[Order-Nr] && Table2[Step Name] = Table1[Step Name] ),Table2[Status])
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |