Forum Discussion

Aditya-2231's avatar
Aditya-2231
New Member
2 years ago

Calculation

Hi I'm pasting an Excel. I want to implement same in power bi. Value is measure that is already present. And need column is ask.
Need Help
Aditya-2231's avatar
Aditya-2231
New Member
2 years ago

Hi ss is already pasted. Same data is pulling in power bi. Thanks

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

Aditya-2231 

pls try this

Column = 
VAR _start=maxx(FILTER('Table','Table'[month]=min('Table'[month])),'Table'[value])
VAR _start2=MINX(FILTER('Table','Table'[month]>min('Table'[month])),'Table'[month])
RETURN _start-sumx(FILTER('Table','Table'[month]>=_start2&&'Table'[month]<=EARLIER('Table'[month])),'Table'[value])

  • Aditya-2231's avatar
    Aditya-2231
    New Member
    2 years ago

    I'm getting circular depedancy error.

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      Aditya-2231 

      you can try this

      measure = 
var _min=CALCULATE(min('Table'[month]),ALL('Table'))
VAR _start=maxx(FILTER(all('Table'),'Table'[month]=_min),'Table'[value])
RETURN _start-sumx(FILTER(all('Table'),'Table'[month]>_min&&'Table'[month]<=max('Table'[month])),'Table'[value])

      pls see the attachment below