Forum Discussion
Need help with DAX
Hi all , I'm unable to get the logic to implement in DAX for one of the queries that I have. Scenario: I've 3 columns namely "Report_Name", "User_List" and "User_status". if a report is shar...
Anonymous
output
Column = var r = Table2[Report_Name] var f= FILTER( Table2, Table2[Report_Name] = r && Table2[User_status] = "Active" ) return IF(ISEMPTY(f),"Delete","Retain")let me know if this works.
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Daniel29195
Community Champion
Community ChampionAnonymous
output
Column =
var r = Table2[Report_Name]
var f=
FILTER(
Table2,
Table2[Report_Name] = r && Table2[User_status] = "Active"
)
return
IF(ISEMPTY(f),"Delete","Retain")
let me know if this works.
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠