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 w...
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

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

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

        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.