DAX formula to find the previous day count

[SaChinKuMarT]

Hi I need a solution to find the previous days count. Where if i click today's date it should show the Yesterday's result.

As an sample i have attached a screenshot here. 

Kindly help with your ideas thank you.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.

Selected day count measure: = 
COUNTROWS( Data )

Previous day count measure: = 
CALCULATE ( [Selected day count measure:], Data[Date] = MAX ( Data[Date] ) - 1 )

[SaChinKuMarT]

Thank you so much JIHWAN_Kim

[Wilson_]

hah, your solution looks simpler and faster than mine Jihwan. 😄

My only comment is I do still prefer SELECTEDVALUE to MAX because the measure only makes sense if exactly one date is selected.

[Wilson_]

Hello!

Try the below measure out and let me know whether it works for you or not. 😄

Yesterday Count = 
VAR Yesterday = SELECTEDVALUE ( Table1[Date] ) - 1

-- Filters your data for yesterday's row
VAR FilteredTable =
FILTER (
    ALL ( Table1 ),
    Table1[Date] = Yesterday
)

RETURN
SUMX (
    FilteredTable,
    Table1[Count]
)