Forum Discussion

SBR1D's avatar
SBR1D
Icon for Helper III rankHelper III
2 years ago
Solved

Calculated table variables

Hello   I've got a table where applicants have multiple rows depending on the application stage they are at.  I want to bring back a table of anyone that is of status code 1 OR 2 AND 5. Here is wha...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SBR1D ,

    Please try to create a new table with below dax formula:

    New Table =
VAR invited_or_new =
    CALCULATETABLE (
        'Application Progress Links',
        'Application Progress Links'[Status (Code)] IN { 1, 2 }
    )
VAR signed_up =
    CALCULATETABLE (
        'Application Progress Links',
        'Application Progress Links'[Status (Code)] = 5
    )
VAR combined_table =
    UNION ( invited_or_new, signed_up )
VAR final_table =
    INTERSECT ( invited_or_new, signed_up )
RETURN
    final_table

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SBR1D ,

Please try to create a new table with below dax formula:

New Table =
VAR invited_or_new =
    CALCULATETABLE (
        'Application Progress Links',
        'Application Progress Links'[Status (Code)] IN { 1, 2 }
    )
VAR signed_up =
    CALCULATETABLE (
        'Application Progress Links',
        'Application Progress Links'[Status (Code)] = 5
    )
VAR combined_table =
    UNION ( invited_or_new, signed_up )
VAR final_table =
    INTERSECT ( invited_or_new, signed_up )
RETURN
    final_table

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.