Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi there
I want to evaluate how many versions per Sales Quotes our company produce in order to achieve a final result.
Business Central adds each "archived" version as a single line to the archives-table, with a row for quote number (which does not change) and a verson number, counting up.
Now I think for my intent I would only need the line per Doc-No. with the highest Version-No.
Is it possible to transform the table to keep only that line per Doc-No. or would I have to keep those and build something else entirely ?
My approach then would be to just add up all version counts. count distinct number of doc-NO and divide and be done with it.
but this doesnt work if I have all lower version numbers inflating the data:
looing forward for any help / suggestion
thanks in advance
@bco_lde , BAsed on what I got
Keep Latest date - Power query (This will remove data)
https://www.youtube.com/watch?v=hidJ5T_DYQ0
https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/
Latest based on DAX measure( no data removal)
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
37 |