Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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)
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)
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
I'm not really practical with DirectQuery so I don't know if that works, to be honest
@Anonymous : That solution worked! Thanks! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |