Filter newest Version of Software

[Anonymous]

Hello,

I am new into Power BI and not  so familiar with DAX yet.

For my dashboard I need to now the newest Version of the HW and the SW of a machine.

Every time when the machine runs, it is creating a row saving the HW and SW version.

In my dashboard I see latest and all old SW and HW versions of a machine.

But I just want to see the latest version of SW and HW?

thank you very much

Kind regards

Simone

Machine	Serial Number	Version HW	Version SW
M2980	192218	33.21	7.0.12
M2980	192218	33.21	7.0.1201
M2980	192218	33.21	7.0.16
M4070	110304	31.23	7.0.12
M4070	110304	31.23	7.0.1201
M4070	110304	31.23	7.0.16
M4071	124665	20.22	7.0.12
M4071	124665	20.22	7.0.1201
M4071	124665	20.22	7.0.16
M4072	212237	37.07	7.0.12
M4072	212237	37.07	7.0.1201
M4072	212237	37.07	7.0.16
M4157	229707	40.21	7.0.12
M4157	229707	40.21	7.0.1201
M4232	140033		7.0.12
M4233	142156		7.0.12
M4234	142157		6.8.24
M4234	142157		7.0.12

[Anonymous]

@amitchandak 

Thank you very much for your fast response.

Unfortenately the "VAR" term always run into a syntax error for ")".
After reserch I didn't found the reason for it.

Kind regards

Simone

[amitchandak]

@Anonymous , Sorry, My mistake

try like

Latest Version SW =
VAR __id = MAX ('Table'[ Serial Number] )
VAR __date = CALCULATE ( MAX('Table'[Version SW] ), ALLSELECTED ('Table' ), 'Table'[Serial Number] = __id )
return
CALCULATE ( MAX ('Table'[Version SW] ), VALUES ('Table'[Serial Number] ),'Table'[Serial Number] = __id,'Table'[Version SW] = __date )

[Anonymous]

@amitchandak 

no proplem, but I also have tried the RETURN command but it still doesn´t work.
Allready after the first variable I get the syntax error:

Latest Calypso Version = 

VAR __id = MAX(LogMerge[Serial Number])

-> Wrong Syntax for ")".(DAX(VAR __id = MAX(LogMerge[Serial Number]))).

The same when I use "1" instead of "MAX(LogMerge[Serial Number])".

Whe I remove both  "__" from "__id" i get the Syntax error

Wrong Syntax for "id".(DAX(VAR id = 1)).

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Please try the following formula:

Measure = 
COUNTROWS (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Machine] = MAX ( 'Table'[Machine] )
            && 'Table'[Version SW] >= MAX ( 'Table'[Version SW] )
            && 'Table'[Version SW] >= MAX ( 'Table'[Version SW] )
    )
)

Then filter this visual with Measure = 1.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can try a measure like this

Latest Version SW =
VAR __id = MAX ('Table'[ Serial Number] )
VAR __date = CALCULATE ( MAX('Table'[Version SW] ), ALLSELECTED ('Table' ), 'Table'[Serial Number] = __id )
CALCULATE ( MAX ('Table'[Version SW] ), VALUES ('Table'[Serial Number] ),'Table'[Serial Number] = __id,'Table'[Version SW] = __date )