Forum Discussion

0xygen27's avatar
0xygen27
Icon for Advocate II rankAdvocate II
9 years ago
Solved

All Except function

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?

Need Help
Show and Tell
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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

7 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    0xygen27

     

    In Modeling - New Table :

     

    Add This:

     

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

    • 0xygen27's avatar
      0xygen27
      Icon for Advocate II rankAdvocate II
      9 years ago

      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's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        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

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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