Compare Weekday to Previous Weekday (Monday to last Monday, Tuesday to last Tuesday, etc.)

[SirBI]

 rundate   checktypeid    state    value    DOW
  6/11/21    1             ALL      250     Friday
  6/10/21    1             ALL      240     Thursday
  6/10/21    2             FL       300     Thursday
  6/10/21    2             FL       310     Thursday
  6/4/21     1             ALL      400     Friday
  6/3/21     2             FL       410     Friday

I want to display in my table the previous weekday value. (For example, see below table)

  rundate    Last_DOW_value
  6/11/21       400
  6/10/21       
  6/10/21       410
  6/4/21          
  6/3/21      

[Jihwan_Kim · Accepted solution]

Hi, @SirBI 

Please check the below picture and the sample pbix file's link down below.

It is for creating measures.

Current Week Value Measure =

SUM ( 'Table'[value] )

Previous Week Value Measure =

CALCULATE (

[Current Week Value Measure],

FILTER (

ALL ( 'Table' ),

'Table'[rundate]

= MAX ( 'Table'[rundate] ) - 7

&& 'Table'[checktypeid] = MAX ( 'Table'[checktypeid] )

&& 'Table'[state] = MAX ( 'Table'[state] )

)

)

https://www.dropbox.com/s/6helnq7hvldkawo/sirbi.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Fowmy]

@SirBI 

If you have a Dates Table then you can create this measure :

Previous Week Value =
CALCULATE ( SUM ( TABLE[Value] ), DATEADD ( dates[date], -7, DAY ) )

 otherwise,

Previous Week Value =
VAR __previousweekdate =
    SELECTEDVALUE ( Table[Date] ) - 7
VAR __previousweekvalue =
    CALCULATE ( SUM ( TABLE[Value] ), table[Date] = __previousweekdate )
RETURN
    __previousweekvalue