Forum Discussion

markyochoa's avatar
markyochoa
Helper I
3 years ago
Solved

Custom Days Between Measure not working

I have an independent calendar that I use for most calculations involving dates. It's a simple 1-column table with dates from 1/1/2021 - 12/31/2023. I'm sure almost everyone is familiar with this pra...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    markyochoa Looks like it has to do with the evaluation of the measures within the FILTER clause, do this instead:

    Days = 
    VAR __Begin = [BeginningMonth]
    VAR __Selected = [SelectedDate]
    VAR __Table = FILTER( 'Dates', [Date] >= __Begin && [Date] <= __Selected)
    VAR __Result = COUNTROWS(__Table)
RETURN
    __Result
markyochoa's avatar
markyochoa
Helper I
3 years ago

Hey Greg_Deckler ,

 

Thanks for the quick response. Unfortunately I get the same result. 

 

I was thinking maybe it was something to do with my dashboard setup, but I created a standalone Pbix with just the Calendar table and the 3 measures and it remains the same.

 

I will say this though, if I change the 1/1/2021 to 1/1/2023 it will work, but that defeats the purpose of why I use the Calendar table in the first place.  

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

markyochoa Looks like it has to do with the evaluation of the measures within the FILTER clause, do this instead:

Days = 
    VAR __Begin = [BeginningMonth]
    VAR __Selected = [SelectedDate]
    VAR __Table = FILTER( 'Dates', [Date] >= __Begin && [Date] <= __Selected)
    VAR __Result = COUNTROWS(__Table)
RETURN
    __Result
  • markyochoa's avatar
    markyochoa
    Helper I
    3 years ago

    Thanks!!!!