Previous day Error

[Anonymous]

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....

[rocky09]

@Anonymous  are you trying to add a column to show Previous Date from the Main Date Column?

[Anonymous]

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