Forum Discussion

kjartank's avatar
kjartank
Helper II
9 years ago
Solved

Using filter on UNION

Hi.   I have been using the "UNION" function to get my charts to be more manageable and am in need of a filter on these tables. The code I've been using looks like this. Satisfaction Score = UNION...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You would use FILTER in your first parameter. So,

     

    SELECTCOLUMNS (FILTER(Table1,[Period] = MAX([Period])); "Attribute";...

    Something along those lines. Would need sample data to get specfic.

     

    You might also want to create a variable where you filter your table and return it and then use that variable in place of Table1 in your SELECTCOLUMNS. Would be more efficient that way.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi kjartank,

Please follow the Greg_Deckler said, filter the table using the highest value of a variable called "Period". Then use the filter table in your formula, don't hesitate to ask if you have any other issue.

Best Regards,
Angelia

  • kjartank's avatar
    kjartank
    Helper II
    9 years ago

    hi v-huizhn-msft

     

    I've tried the solution that Greg_Deckler suggested and I got an error. I'm not sure why, but the error message reads "Cannot identify the table that contains [period] column."