Forum Discussion

Kavyachaganti's avatar
Kavyachaganti
Regular Visitor
3 years ago

Getting previous row data from other column in Power BI #

Hi All,
 

I need to add below calculation(Table2) in Power BI Report. Can someone of you please help me on this.

Table1:

 

Table2: Below calculation to be added in Power BI.

 

 

Need Help

1 Reply

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    pls try this

     

    Measure1  = IF(ISNUMBER('tabl'[py]),'tabl'[py],0)
Measure2 =  SUM('table'[y])+1