Forum Discussion

gdexter's avatar
gdexter
Frequent Visitor
8 years ago
Solved

Cumulative sum IMPOSSIBLE?

Dear Power BI Community,   NEED YOUR HELP!   I want to create a measure for cumulative total of the EarlyOccurences data (shown below). I have attempted to use following the DAX formula to...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey gdexter

     

    Similar to what jthomson said, you shouldn't have an opening parentheses before the ALL function. The filter should look like:

     

    FILTER(
   ALL('Date'[Daily]),
   'Date'[Daily] <= MAX('Date'[Daily])
)

    Hope this helps,

    Parker

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey gdexter

 

Similar to what jthomson said, you shouldn't have an opening parentheses before the ALL function. The filter should look like:

 

FILTER(
   ALL('Date'[Daily]),
   'Date'[Daily] <= MAX('Date'[Daily])
)

Hope this helps,

Parker

 

 

  • gdexter's avatar
    gdexter
    Frequent Visitor
    8 years ago

    Thanks a lot for the super fast reply! Was in fact too many brackets. I'm new to DAX, had no idea they could mess things up

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      A good trick to follow is that if Intellisense does not allow you to type the function you want, then you either have a syntax error or you can't use the function where you are trying to use it!