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

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.

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