Forum Discussion

UrAvgWally's avatar
UrAvgWally
Icon for Helper I rankHelper I
4 years ago
Solved

Cumulative Total , no dates

Hi all,   I am trying to turn this line chart into a cumulative chart :      The data Source looks like this , the X axis is the period Column   The Y Axis is based on these values...
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    UrAvgWally Yeah, there is a stray ) in there:

    Measure = 
VAR PNo = MAX(PeriodicTable[PeriodNo])
VAR Periods = 
  SELECTCOLUMNS(
    FILTER(
      ALL(PeriodicTable), 
      [PeriodNo] <= PNo
    ),
    "__PeriodMFMA",
    PeriodicTable[PeriodMFMA]
  )
VAR Table = FILTER(UnpivotCP,[PeriodMFMA] IN Periods)
RETURN
SUMX( Table,[Value])
UrAvgWally's avatar
UrAvgWally
Icon for Helper I rankHelper I
4 years ago

Alright, thanks . Thank you for being patient with me. Will start reading the book on Dax over the weekend to learn, it is arriving tommorow. 

 

The Allexcept is having syntax error :

 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

UrAvgWally ALLEXCEPT takes additional parameters. So something like:

VAR Table1 = FILTER(ALLEXCEPT(UnpivotCP, 'UnpivotCP'[Function]),[PeriodMFMA] IN Periods)

So that code would ignore all context other than context created by a Function column in your UnpivotCP table for example.