Forum Discussion

New_be's avatar
New_be
Helper V
6 years ago
Solved

Read previous rows from dates

Hi everyone! Im still new in power bi. Currently working on this project where i need to show the date for yesterday. For example in the image, if my date is 22/5/2020 (friday), i need to get t...
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    New_be 

     

    Try this

    Column =
VAR _PreviousDay =
    MAXX (
        FILTER (
            MyTable,
            MyTable[Date]
                < EARLIER ( MyTable[Date] )
                && MyTable[Status] <> "OFF"
        ),
        MyTable[Date]
    )
VAR _result =
    SUMX (
        FILTER (
            MyTable,
            MyTable[Date]
                < EARLIER ( MyTable[Date] )
                && MyTable[Date] >= _PreviousDay
        ),
        MyTable[Cost]
    )
RETURN
    _result



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂

amitchandak's avatar
amitchandak
Super User
6 years ago

New_be , Two new columns like that.

 

Work Date = if(WEEKDAY([Date],2)>=6,BLANK(),[Date]) //OR
Work Date = if([Status]="OFF",BLANK(),[Date]) 
Last working date = maxx(filter('Date','Date'[Work Date]<EARLIER('Date'[Work Date])),'Date'[Work Date])