Previous Date Vs Today Variance

[Gokul_G16]

Hi Experts,

Need you assitance to build the below figure shown measure varince to be as per the data avaialble value only should calculate the variance.
--

Coulmn 1 is : Count trend 

Coulmn 2 is : Variance of previous day Vs Today. ( Inside the  column 2 i should be have continous variance of previous date value comparsion.

Currently measure work around :

variance = Dateadd(date, -1, Day)

Your valuable responce to be highly prompt.

Thanks, 

Gokul.

[Jonvoge]

Hi Gokul_G16

One issue in your report seems to be the missing dates.

I am guessing that you are using a Date column from your Fact Table, and not a separate Date Table?

I would highly advice you to use a Date Table, in order to fill out the blank dates in your table.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Gokul_G16]

Hi @Jonvoge ,

Thanks for responce,

Yes, aggreed it the date are missing. it seems our end weekends are excluded.

I have used measure seprate dim_date master only. Is there any possible to make the based on Fact table rows available to be calulated the variance Previous day - Today Variance Count.

Thanks,
Gokul

[Gokul_G16]

Hi @amitchandak @Arul 

Need your concerence on this.

Thanks
Gokul

[Arul]

@Gokul_G16 ,

Can you try Visual Level Calculation?