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

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