Forum Discussion
drogzy
Helper I
Helper IHelp in using dax to reference columns that are using direct query
Hi all, I understand when referencing coulmns while using dax you have to insert SUM, MIN, MAX, AVERAGE in the measure but how does that work when you have text or dates. I am trying to create...
You can use MAX or MIN on date fields and text fields (it uses alphabetical sorting) but I usually prefer to use SELECTEDVALUE for text like this:
IF ( SELECTEDVALUE ( Table1[Job] ) = "Field", MAX ( Table1[Start] ) )However, DirectQuery can handle simple calculated columns like this just fine whether you add them in the query editor as a custom column (if [Job] = "Field" then [Start] else null) or as a calculated column in DAX: IF ( Table1[Job] = "Field", Table1[Start] )
A couple of possibilities:
IF ( SELECTEDVALUE ( Table1[Job] ) IN { "Field", "Office" }, MAX ( Table1[Start] ) )or
VAR _Job = SELECTEDVALUE ( Table1[Job] ) RETURN IF ( _Job = "Field" || _Job = "Office" MAX ( Table1[Start] ) )
drogzyHelper I
Helper IThank you, this works.
What would the code look like if you had more than 1 if condition?
Ex: IF ( SELECTEDVALUE ( Table1[Job] ) = "Field" or "Office", Max (Table1[Start]) )
Thanks
AlexisOlson
Super User
Super UserA couple of possibilities:
IF (
SELECTEDVALUE ( Table1[Job] ) IN { "Field", "Office" },
MAX ( Table1[Start] )
)or
VAR _Job = SELECTEDVALUE ( Table1[Job] )
RETURN
IF (
_Job = "Field" || _Job = "Office"
MAX ( Table1[Start] )
)