Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table called "Order Summary" with 10k+ rows and the following columns:
order_ID | date | account_number | previous_order_ID | previous_order_date | time_elapsed |
data | data | data | ??? | ??? | ??? |
(the table has an addition 29 columns, like company information, qty, payments, etc. They are not relevant to this question, but it should be noted that they are there)
The first 3 columns make up my dataset already - It's the last 3 columns I'm trying to fill in. That is to say:
for each individual row of unique order_ID, I want to know
My first hurdle is identifying the MAX [order_ID], but limiting it to the specific company in the row AND ensuring that it is less than the [order_ID] in the specific row.
Thanks!
Thanks! I appreciate your time. I had a look, but it wasn't in the direction I was trying to go in. I tried rewording the question in a different way and found some code that worked.
If anyone is looking in the future, try here:
Apologies. Must have forgot to add the link.
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
I think you can use this tutorial by Radacad to creare a group by per ID. You could then add a MAX row in the group by step to get the max value of the column