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:

FreemanZ's avatar
FreemanZ
Super User
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: