Forum Discussion

elouizi's avatar
elouizi
Icon for Helper II rankHelper II
6 years ago
Solved

Previous duration record

Hi,   I am new to Power BI. I want to calculate the previous duration record of a project. I have being trying with Earlier function. But that did not work for me. Please dont use previousYear-fucn...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    This calculated column works fine

    =LOOKUPVALUE('Duration'[Duration],'Duration'[Date],CALCULATE(MAX('Duration'[Date]),FILTER('Duration','Duration'[Brand]=EARLIER('Duration'[Brand])&&'Duration'[Date]<EARLIER('Duration'[Date]))),'Duration'[Brand],'Duration'[Brand])

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

This calculated column formula works

=LOOKUPVALUE(Data[DurationinMinutes],Data[Date],CALCULATE(MAX(Data[Date]),FILTER(Data,Data[Brand]=EARLIER(Data[Brand])&&Data[Date]<EARLIER(Data[Date]))),Data[Brand],Data[Brand])

Hope this helps.

  • elouizi's avatar
    elouizi
    Icon for Helper II rankHelper II
    6 years ago

    Looks amazing. Is there a way I can use it as a messaure? Because I need to do other calculations, otherwise I need to create a lot of columns (which will impact the performance)

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Whom are you replying to?  Did my calculated column formula work?

  • elouizi's avatar
    elouizi
    Icon for Helper II rankHelper II
    6 years ago

    Hi Ashish_Mathur,

     

    My replay was to you. :).

    I dont know why, but it says that it cannot find the column "brand" and the "date" columns.
    Is there another way I can solve this without creating a colum? Otherwise I may need to create lots of other columns

     

    Thanks!