how to add into new column value YES or NO according to version of file visible in another columns

[Gandhary80]

I need to get a YES or NO value in column "E", according to the following rule:
The document number is in column B.
The document has X lines and is created in the system sequentially.
The procedure is that according to column D I have to find the document with the highest version number
And then it can also happen that the one with the highest number in column D has more variants, subversions, which are listed in column C.

Thus, for example, the rows with document name SZ-23-00363 will have YES if they have the value 4 in column D and 4 in column C, while the rows with document name SZ-23-00364 will be valid if they have the value 2 in D and also 2 in column C.

[rajendraongole1 · Accepted solution]

Hi @Gandhary80 - you can create a calculated column in Power BI using DAX. This column will check for the highest version number in column "D" and the highest subversion number in column "C" for each document in column "B" and then mark the rows 

for highest version , you can create measure as below:

Max Version =
CALCULATE(
MAX(Table[D]),
ALLEXCEPT(Table, Table[B])
)

another measure for subversion :

Max Subversion =
CALCULATE(
MAX(Table[C]),
ALLEXCEPT(Table, Table[B], Table[D])
)

Now you can add calculated column with Yes or No add it to the table chart. 

Valid Document =
IF(
Table[D] = [Max Version] && Table[C] = [Max Subversion],
"YES",
"NO"
)

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!