How to validate data with list of items using DAX

[ravitejaballa]

Hi Team,

In my app, i am trying to validate does device have latest software version.

Device	Application	AppVersion	IsSoftwareUptoDate
A	PowerBI	3Jan2018	No
B	PowerBI	15Feb2019	No
C	PowerBI	5Nov2019	Yes
D	PowerBI	10Feb2020	Yes

I created column "IsSoftwareUptoDate" to validate with hard coded "AppVersion" value like below.

IsSoftwareUptoDate =

var version1 = "5Nov2019"

var version2 = "10Feb2020"

RETURN

IF(

OR (version1 == [AppVersion], version2 == [AppVersion]),

"Yes",

"No"

)

But now i want to get AppVersion from master data instead of hardcoded value.

My Master Data:

Application	LatestSoftwareVersion
PowerBI	10Feb2020 | 5Nov2019

Note: "LatestSoftwareVersion" can have multiple version with delimiter '|'

I applied 'Text.Split([LatestSoftwareVersion], "|")'  and made list to create new row, so table will be

Application	LatestSoftwareVersion	listOfVersions
PowerBI	10Feb2020 | 5Nov2019	10Feb2020
PowerBI	10Feb2020 | 5Nov2019	5Nov2019

Now i want to use "listOfVersions" to validate "AppVersion" using DAX.

[Mariusz · Accepted solution]

Hi @ravitejaballa 

Please see the attached file with 2 approaches, one Power Query and second DAX Measure.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn