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

6 Replies

    • 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])