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 20/03/2019
when i do previousday
it only shows up
Company Name Value Previous Day
Company A 1 2
its not even showing the company B
how can i fix it....i really need this fixed....
2 Replies
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
