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 the "fixed funded count" column to instead of summing the entire time i select in my date slicer, to show the total for each month. so the first and second columns should match, but they dont:

 

 

here is my formula:

 


Here is my calendar table:

 

Any thoughts?

 






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]))

4 Replies

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi, Anonymous 

    try to add .month after date in allexcept
    like 

    CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[date].[Month]))
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      that did SOMETHING - it now pulls the sum of the counts for the entire data set time period.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      this worked actually, i just needed to add same with .year as well. Thank you so much!!

  • 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