Forum Discussion
Split stacked column based on true/false indicator, counting only distinct, latest values
Hi. I’m new to Power BI and I’ve been given some tasks which I can’t get my head around. I’m reporting trades to a third party and single trade can be sent several times on different dates. If it is...
I guess I need to first filter the data based on sent_date, then find the max sent_date for every trade_id.
Once I have those, join the two values (max sent date and trade id) back to data table and find the trade_date and Late columns.
Or am I on wrong track here?
Once I have those, join the two values (max sent date and trade id) back to data table and find the trade_date and Late columns.
Or am I on wrong track here?
v-chuncz-msft
Community Support
Community Support
You may try to use RANKX Function. The post below is for your reference.
http://community.powerbi.com/t5/Desktop/How-to-get-the-latest-status-by-id/m-p/260538#M116405