Forum Discussion

Nemes's avatar
Nemes
Frequent Visitor
8 years ago
Solved

Issues with measure using time intelligence

Hello,   I've been running into issues when creating measures, particularly with time intelligence (for example SAMEPERIODLASTYEAR).   Here is a stripped down version of my report, with only the ...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Nemes

     

    How about this one

     

    Total Amount Last Year =
CALCULATE (
    [Total Amount],
    SAMEPERIODLASTYEAR ( 'Dates'[Date] ),
    ALL ( Dates )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Nemes

 

How about this one

 

Total Amount Last Year =
CALCULATE (
    [Total Amount],
    SAMEPERIODLASTYEAR ( 'Dates'[Date] ),
    ALL ( Dates )
)
Nemes's avatar
Nemes
Frequent Visitor
8 years ago

That does seem to work! I thought I tried this before, but I think I tried ALL('Dates'[Date]) instead of ALL(Dates). I'm not sure why specifying only the Date column as an argument to ALL doesn't work, considering thre are no date duplicates.

 

Would you know why I need to specify the ALL() function, unlike all of the other how-to's and guides that I've found on this subject?