Forum Discussion

Gokul_G16's avatar
Gokul_G16
Resolver I
2 years ago

Previous Date Vs Today Variance

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.



Data Protection
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • Jonvoge's avatar
    Jonvoge
    Most Valuable Professional
    2 years ago

    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's avatar
      Gokul_G16
      Resolver I
      2 years ago

      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