Forum Discussion
KW123
Helper V
Helper VSubtracting two rows
Hi, I am hoping someone can help. I have a column with sales values and I need to create a DAX where I minus A from B to get C but then take C and minus it from B to get D. Then D-B=E etc for t...
Hi KW123
Sorry it was too late yesterday I couldn't reply to you. Here is a sample file with the solution jnowing that you will retun back to me with more information that you've been hiding as usual 😉https://www.dropbox.com/t/lzKxh0DxLA056sy7Result = VAR A = 1000 VAR B = 10 VAR CurrentIndex = SELECTEDVALUE ( Data[INDEX] ) VAR MaxIndex = CALCULATE ( MAX ( Data[INDEX] ), ALLEXCEPT ( Data, Data[Day].[Month] ) ) RETURN IF ( CurrentIndex <> BLANK ( ), A - ( MaxIndex - CurrentIndex ) * B )What does YTD total need to be = VAR A = [Accounting goal calc-c] VAR B = [Daily Goal] VAR CurrentIndex = SELECTEDVALUE ( Dates[FD2] ) VAR MaxIndex = CALCULATE ( MIN ( Dates[FD2] ), ALLEXCEPT ( Dates, Dates[Date] ) ) RETURN IF ( DAY ( SELECTEDVALUE ( Dates[Day] ) ) = 1 && MONTH ( SELECTEDVALUE ( Dates[Day] ) ) = 1, 0, IF ( CurrentIndex <> BLANK (), A + ( MaxIndex - CurrentIndex ) * B ) )
KW123Helper V
Helper Vtamerj1 This works thank you!!! Now it's making each first of each month $0. I just need it to make January 1 = $0
tamerj1
Community Champion
Community ChampionWhat does YTD total need to be =
VAR A = [Accounting goal calc-c]
VAR B = [Daily Goal]
VAR CurrentIndex =
SELECTEDVALUE ( Dates[FD2] )
VAR MaxIndex =
CALCULATE ( MIN ( Dates[FD2] ), ALLEXCEPT ( Dates, Dates[Date] ) )
RETURN
IF (
DAY ( SELECTEDVALUE ( Dates[Day] ) ) = 1
&& MONTH ( SELECTEDVALUE ( Dates[Day] ) ) = 1,
0,
IF ( CurrentIndex <> BLANK (), A + ( MaxIndex - CurrentIndex ) * B )
)