Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Subtracting from the same column based on selected filter

Hi Power Bi Community,  I need your support on writting DAX commend.  I've a table that consist of project ID and Turnover over the years.     Project ID Turnover MEUR Year ID99 0,1 ...
DAX Calculation
DAX FILTER
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Please refer to the sample with the solution https://www.dropbox.com/t/80L2KufXOL8k8xLc

    Turnover YOY = 
VAR CurrentYer = SELECTEDVALUE ( Turnover[Year] )
VAR FirstSelectedYear = CALCULATE ( MIN ( Turnover[Year] ), ALLSELECTED ( Turnover ) )
VAR CurrentValue = SUM ( Turnover[Turnover MEUR] )
VAR PreviousValue = CALCULATE ( SUM ( Turnover[Turnover MEUR] ), Turnover[Year] = CurrentYer - 1 )
RETURN
     IF (
         CurrentYer <> FirstSelectedYear,
        CurrentValue - PreviousValue
     )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
Please refer to the sample with the solution https://www.dropbox.com/t/80L2KufXOL8k8xLc

Turnover YOY = 
VAR CurrentYer = SELECTEDVALUE ( Turnover[Year] )
VAR FirstSelectedYear = CALCULATE ( MIN ( Turnover[Year] ), ALLSELECTED ( Turnover ) )
VAR CurrentValue = SUM ( Turnover[Turnover MEUR] )
VAR PreviousValue = CALCULATE ( SUM ( Turnover[Turnover MEUR] ), Turnover[Year] = CurrentYer - 1 )
RETURN
     IF (
         CurrentYer <> FirstSelectedYear,
        CurrentValue - PreviousValue
     )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi tamerj1 , 

     

    Worked like a charm! Thanks for such detailed sulution!