Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum previous year

Hi, that's my graph:   With the blue line (that's a simply distinct count) i need to sum the previous year to the current year.   So, it will become:   2014: 819 2015: 2412 + (819) 201...
Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    try a measure

    Measure = CALCULATE(SUM('Table'[Codici]),FILTER(ALL('Table'),'Table'[Year]<=MAX('Table'[Year])))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

it should be count as 2!

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mid-question

 

these 2 columns are the same format: data type.

 

Why BI show me only one like a hierarchy?

 

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    I think its because "Valido da" field is not clean, maybe it has an error values. check it in source and Power QUery editor. If everything is ok, set data type as date in Power query editor mode