Forum Discussion
Previous day Error
I am trying to get some stuff together i have company name value date Company A 2 19/03/2019 Company B 4 19/03/2019 Company A 1 ...
Anonymous are you trying to add a column to show Previous Date from the Main Date Column?
My tables are as follows and i dont have a separate table connected to it
Date company count
13/03/2019 A 2
13/03/2019 B 3
13/03/2019 C 2
14/03/2019 A 2
14/03/2019 B 1
My formula looks like
Yesterday=Calculate(count(count),previousday(date)
When i use slicer on the date on 14/03/2018
Result comes like
Today yesterday
Company A 2 2
Company B 1 3
Here everything works except company C not showing up
That is the only problem
Date company count
13/03/2019 A 2
13/03/2019 B 3
13/03/2019 C 2
14/03/2019 A 2
14/03/2019 B 1
My formula looks like
Yesterday=Calculate(count(count),previousday(date)
When i use slicer on the date on 14/03/2018
Result comes like
Today yesterday
Company A 2 2
Company B 1 3
Here everything works except company C not showing up
That is the only problem