Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

RE: subtract between two rows of the same column 

Nov 10, 2021 06:40 AM
Statistics
0 Favorited
34 Views
1 Files
0 Shares
1 Downloads
Attachment(s)
pbix file
Test.pbix   29 KB   1 version
Uploaded - Nov 10, 2021

Comments

Jan 15, 2022 02:30 PM


Steps to populate differrence between two immediate rows in same column to another column(A2-A1)

step 1-create two index column from Add column section ie one starting with 0 with column name as Index and another index column starting with 1 with name Index.1

Step2-Add a new column with respective name and use the below formula and enter

var diff= Table column name-CALCULATE(SUM(Table column name),FILTER('tablename','tablename'[Index.1]=EARLIER('insights-logs-connection'[Index]))) return IF (diff=VALUE(Table column name),0,diff)

Table column name will be like 'table name'[column name] choose automaticaly from power BI list dropdwon

Table name will be like 'table name' choose automaticaly from power BI list dropdown

Related Entries and Links

No Related Resource entered.