Forum Discussion
Solved
Subtracting Columns
Hi there Power BI Community.... I need your help, please. I need to create a measure that subtracts the preceding column from the next and displays the answers only (in bold red below). Exampl...
BICrazy
Here is your measure:Measure = VAR CV = MAX(Table1[Value]) VAR D = SELECTEDVALUE(Table1[Day])+1 RETURN CV- CALCULATE( MAX(Table1[Value]), Table1[Day] = D, ALLSELECTED(Table1[Day]) )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
Thanks Fowmy,
The measure worked like a charm. I just inserted the portion to accommodate the blanks on my data set.Previous Index Policies = VAR CV = [Bank Submissions] VAR D = SELECTEDVALUE('Ongoing & Unpaid Data Revised'[Index])+1 RETURN CV- CALCULATE( [Bank Submissions], 'Ongoing & Unpaid Data Revised'[Index] = D && CV <> BLANK(), ALLSELECTED('Ongoing & Unpaid Data Revised'[Index]))
BICrazy
Here is your measure:
Measure =
VAR CV = MAX(Table1[Value])
VAR D = SELECTEDVALUE(Table1[Day])+1
RETURN
CV-
CALCULATE(
MAX(Table1[Value]),
Table1[Day] = D,
ALLSELECTED(Table1[Day])
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
Thanks Fowmy,
The measure worked like a charm. I just inserted the portion to accommodate the blanks on my data set.Previous Index Policies = VAR CV = [Bank Submissions] VAR D = SELECTEDVALUE('Ongoing & Unpaid Data Revised'[Index])+1 RETURN CV- CALCULATE( [Bank Submissions], 'Ongoing & Unpaid Data Revised'[Index] = D && CV <> BLANK(), ALLSELECTED('Ongoing & Unpaid Data Revised'[Index]))