All Except function

[0xygen27]

Hello Guys, 

I was trying to use the AllExcept function, but it doesn't work.

I am trying to filter out the years in a column with quarters and years. 

I used the following code: 

Dataset weken = ALLEXCEPT('Dataset Fusies','Dataset Fusies'[Perioden], 'Dataset Fusies'[Perioden]="2007JJ00")

Name of the table = AllExcept('Sheet1','column1','row = "2007JJ00"||'column1','row = "2008JJ00")

What is it I am doing wrong?

[v-huizhn-msft]

Hi @0xygen27,

Have you resolved your issue based on the @Vvelarde posted? If it has, please mark the right reply as answer, which will help more people find workaround. If it doesn't, please feel free to ask and post more details.

Best Regards,
Angelia

[Vvelarde]

@0xygen27

In Modeling - New Table :

Add This:

Name of the table = Filter('Sheet1','column1'= "2007JJ00"||'column1'= "2008JJ00")

[0xygen27]

@Vvelarde This isn't what I meant. I want want to exclude the years. I got a column with 4 rows for the quarters of a year and 1 row for the total of that year. I don't want the years, I want only the quarters. So I figured out the quickest way was to exclude the years.

[v-huizhn-msft]

Hi @0xygen27,

Is there any chance to post some sample data for further analysis? And list your expected result.  So we can provide the solution which is close to your requirement.

Best Regards,
Angelia

[0xygen27]

I only want the quarters(20XXKW01-20XXKW04) XX = everthing from 2008 till 2016. The document has like 10.000 rows, not really looking forward to exclude all.

[v-huizhn-msft · Accepted solution]

Hi @0xygen27,

You can use the following formula to get year.

Year=LEFT(Table[Periodin])

Then use the new calculated field in ALLEXCEPT.

Best Regards,
Angelia

[0xygen27]

I only want the quarters(20XXKW01-20XXKW04) XX = everthing from 2008 till 2016. The document has like 10.000 rows, not really looking forward to exclude all.