Forum Discussion
Create conditional flag
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
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)
4 Replies
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)