Select last version entry of an incremental table

[deumdo]

Hi together,

I am very new and unexperienced to Power BI and need some support how to handle a table with incremental updates.

Challenge:

• I get a table out of Azure with incremental updates of product registrations
• Each updated information is delivered as a new row
• Also the version no. of the specified asset is delivered
• I have an unique identifier for each asset (asset ID)

Problem:

• I only want to consider the last (highest) version of an asset

Example:

Asset ID	Content.version	Product Name	Reg. Date	Product Number	Serial no.
ff906c2e-3986-433e-b3e1-3ae0e4e8bd00	1	Car
ff906c2e-3986-433e-b3e1-3ae0e4e8bd00	2	Car	30.06.2020
ff906c2e-3986-433e-b3e1-3ae0e4e8bd00	3	Car	30.06.2020	554	123

The example above is counted 3 times in my dashboard.

I would like to consider only the highest version (row 3) of an asset.

Unfortunately I also have assets with versions up to because users change the version no. often.

I have already tried to implement measures but nothing is working.

MeasureLastUpdate =

VAR LatestVersion=

CALCULATE(MAX(TableInventoryassets0[Content.version]); ALL(TableInventoryassets0))

RETURN

IF(MIN(TableInventoryassets0[Content.version]) = LatestVersion;1;0)

I need so a kind of a filter which considers the asset id and the version number.

It would be great if you can support me.

Thank you very much for your efforts.

[amitchandak]

@deumdo , Try a measure like

Measure = 
VAR __id = MAX ( 'Table'[Asset ID] )
VAR __date = CALCULATE ( MAX( 'Table'[Content.version] ), ALLSELECTED ( 'Table' ),  'Table'[Asset ID] = __id ) 
RETURN CALCULATE ( count ( 'Table'[Product Name] ), VALUES ( 'Table'[Category ), 'Table'[Asset ID] = __id, 'Table'[Content.version] = __date )