Forum Discussion

lapa44's avatar
lapa44
Regular Visitor
8 years ago
Solved

Daily Delta Time Intelligence

Hi   I'm trying to figure out how to calculate daily changes (delta) in a time series. At the same time I need to be able to handle missing days and setting the value to zero on those days, and on ...
  • davehus's avatar
    davehus
    8 years ago

    Hi lapa44 - 

     

    Without see a sample of the data, I'm making a few assumptions. If the dates with blanks are in your data set then you can use a find and replace to change the null values to zero in the query window. If there are specific days where you need the data to be 0, then you can create a seperate date table and merge with your fact table and create a conditional column to set the specific dates to 0

     

    In terms of the delta change.. You can download a sample file here..

     

    https://drive.google.com/file/d/14GpDdpFTgDL5NV73vHU7P20mJxVCxHPD/view?usp=sharing

     

    Hope this helps.

     

    D

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi lapa44,

 

The solution of davehu should close your case.

 

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask.

 

Best Regards,

Cherry