Forum Discussion

denealst's avatar
denealst
New Member
3 years ago
Solved

Select, Return and Conectate multiple fields based on criteria

I've been searching for awhile but can't quite find a query to return what I'm hoping to get. To keep it simple, I'm trying to write a query that can have multiple correct returns and, if I'm not ask...
CALCULATE
CONCATENATEX
IF AND with multiple conditions
question
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi denealst 

    try to add a column like this:

     

    Columnn = 
VAR _target = [Target]
VAR _table =
CALCULATETABLE(
    VALUES(fluids[ID]),
    fluids[Min]<=_target
         &&fluids[Max]>=_target,
    ALL(Assets)
)
RETURN
CONCATENATEX(
    _table,
    fluids[ID],
    ", "
)

     

     

    it shall work like this:

denealst's avatar
denealst
New Member
3 years ago

Marvelous! Late in the evening it came to me that I was trying to build another array and would need an intermediate table to populate out the results of the query and then concaten it. But you have saved me a lot more time because I'd have actually created another table to do it. I didn't know you could create a table as a variable. Very cool! Thanks a ton for the input. I'm no data analyst, just a guy trying to get an edge on how I do my job so folks like you are heroes in my book.