Forum Discussion
COUNTIF
Hi All, I am confused why there is variance between these two approach. To count the member where conditions are: a. status = closed or resolved b. date is Yesterday I created measure cl...
hi schoden You need something like this, in order to have the correct calculate.
Whit variables is easier and clear.
mesuare =
VAR lastday = PREVIOUSDAY('Table'[Date])
var calculat = CALCULATE(SUM('Table'[value]), 'Table'[Date] = lastday)
return calculat
I leave you the .pbix here https://1drv.ms/u/s!AtEkAF7ffIsqg8RU_Q8H3f_rdntrBA?e=b8fdVl
Anonymous Hi
Thanks for sharing the file. Previousday function takes back one day earlier any Day a user chooses in the date slicer.
But I want to set the date to YESTERDAY , user dont have to choose the date in slicer. It is set to YESTERDAY automatically so when day goes , automatically it shows a day before today.