topic Re: Filter newest Version of Software in DAX Commands and Tips

Filter newest Version of Software

Anonymous — Fri, 04 Feb 2022 07:41:49 GMT

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

Re: Filter newest Version of Software

amitchandak — Fri, 04 Feb 2022 08:21:20 GMT

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 )

Re: Filter newest Version of Software

Anonymous — Fri, 04 Feb 2022 10:57:50 GMT

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

Re: Filter newest Version of Software

amitchandak — Fri, 04 Feb 2022 13:45:39 GMT

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 )

Re: Filter newest Version of Software

Anonymous — Fri, 04 Feb 2022 14:32:11 GMT

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)).

Re: Filter newest Version of Software

v-kkf-msft — Wed, 09 Feb 2022 09:10:25 GMT

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.