Forum Discussion

Guyakobov's avatar
Guyakobov
Helper II
7 years ago

previous value

HI,   I would like to get the previous value. so when I choose date 12.03.18 my profit will be -123960.45 and not -116778.37 http://prntscr.com/mtzgw5   Thanks 
Need Help
Guyakobov's avatar
Guyakobov
Helper II
7 years ago

Hi,

 

I want to use the slicer so the start date will show the previous value - im not gonna use the date picker.

 

I tried the new formula and still blank http://prntscr.com/mu2ifa 

 

Test231 =
VAR _PrevMax =
CALCULATE(MAX('floating pl'[Time]),FILTER(ALL('floating pl'),'floating pl'[Time]<SELECTEDVALUE('floating pl'[Time]) && 'floating pl'[Login] = SELECTEDVALUE('floating pl'[Login]) ))
RETURN CALCULATE(FIRSTNONBLANK('floating pl'[Profit],0),'floating pl'[Time] = _PrevMax)

 

 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Guyakobov ,

 

You should select Login too. Or SELECTEDVALUE('floating pl'[Login])  is blank. Please give it a try.

 

 

Best Regards,

  • Guyakobov's avatar
    Guyakobov
    Helper II
    7 years ago

    HI,

     

    still doesn't work, I want a column that will give me the previous row with separation from each account.

     

    http://prntscr.com/mulbdm

     

    Thanks 

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Guyakobov ,

       

      You mean you need a calculated column. If so, you can't make it dynamic with a slicer. Please try out the formula below as a calculated column.

       

      Previous =
VAR currentAccount = [account]
VAR currentTime = [time]
VAR previousDate =
    CALCULATE (
        MAX ( 'table'[time] ),
        FILTER (
            'table',
            'table'[account] = currentAccount
                && 'table'[time] < currenttime
        )
    )
RETURN
    CALCULATE (
        SUM ( 'table'[profit] ),
        FILTER (
            'table',
            'table'[account] = currentAccount
                && 'table'[time] = previousDate
        )
    )

       

       

      Best Regards,

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Guyakobov ,

       

      Could you please mark the proper answers as solutions?

       

       

       

      Best Regards,