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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
amitchandak
Super User
Super User

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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