Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

ALLEXCEPT fixed calc by month

I am trying to use the ALLEXCEPT function with a date in a calendar table. Basically, i want to tell it to allow it to filter to the month of the dates selected in the filter.   I am trying to get ...
Tips and Tricks
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, Anonymous 

    try to add .month after date in allexcept
    like 

    CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[date].[Month]))
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, Anonymous 

make a new column for month in Calender table
and use it in allexcept

if still not working then provide data