Forum Discussion
kjartank
Helper II
Helper IIUsing 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...
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.
kjartankHelper II
Helper IIHi v-huizhn-msft and Greg_Deckler
An embarrasing fault from my side. The solution that Greg_Deckler works just fine. I should have replaced the comma with a semicolon, which I didn't do at first. So please accept my apologies. Thanks a lot. It runs beautifully now!
- Greg_Deckler
Community Champion
kjartank - Apologies for the comma versus semi-colon! Still haven't mastered those localization differences!