Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bco_lde
Helper I
Helper I

Transforming Data - Sales orders and archived versions (Business Central Data) - Or DAX ?

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. 

bco_lde_0-1666853310414.png

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

1 REPLY 1

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.