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
    Icon for Super User rankSuper 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
        Icon for Super User rankSuper 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