Create conditional flag

[Anonymous]

Hello!

I have an typical issue. In my cube, I have some project related data. That has version number. So for example, 

Project number        Version

36002                         v001

36002                         v002

36390                         v001

Now in the report, if a user selects the project then the data attached to latest version (for project 36002-- v002, for project 36390-- v001) should be shown. One way to solve is to create a flag which can be then used to filter the report like:

Project number        Version      IsActive

36002                         v001              0

36002                         v002              1

36390                         v001              1

This flag is currently not available in the cube. So I will need to create it. What DAX query should be used to update this flag?

Regards

Priya

[Anonymous · Accepted solution]

are you working in import or direct query?

can you strip the "v" so the version number will be an actual integer?

If so, you could have a calculated column with 
IsLatest=
var thisProject=Yourtable[ProjectNumber]
VAR thisVersion=YourTable[Version]
RETURN
IF(MAXX(FILTER(YourTable;YourTable[ProjectNumber]=thisProject);Yourtable[Version])=thisVersion;1;0)

[Anonymous]

Thank you @Anonymous for the quick reply. I am using direct query for reading the data. Yes i can create one more calculated column where i dont take "v" into version number

Regards

Priya

[Anonymous]

I'm not really practical with DirectQuery so I don't know if that works, to be honest

[Anonymous]

@Anonymous : That solution worked! Thanks! 🙂