Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Missing data points in timeseries - should be zero values not blanks

Hi Experts

see attached pBIX file.

https://www.dropbox.com/s/ydq2qg1izmu0j6k/Sample__v.1.13.pbix?dl=0

Refer to tab sample data, refer to table (see image below)

 

 

 

 

 

 

 

 

 

 

 

 

1. I want to show the missing data points in any time seris as zero, as opposed to blanks, the above example is based on filters. I have a page level filter based on Y which is for a period of 12 months (i.e. July 2018 to June 2019)  only those data points need to be zero. ignore all others.

 

my dimdate table is PMS_FINANCIAL_PDS

my sales table is PMS_TM1_SALES_VOLUME which has a zero value for each material_id and i still cannot get zero into my table.

 

2.  is an example i have found online in the power bi community forum see image.

The example explains how if you have no data points your timeseries and a new table was created the observations are shown as zero...i want to be able to use this format in my measures __freq and __S also.

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    what about something like this:

    Measure 2 = if( ISBLANK([PMSComplaintsMN]),0,[PMSComplaintsMN])
    • Anonymous's avatar
      Anonymous
      Not applicable

      hi nick

      the zeros have to be for those data points only 12 months. July 18 to June 19

    • Anonymous's avatar
      Anonymous
      Not applicable

      hi nick

       

      i have zero values for all material_id i the Sales table but not the complaints table...if that helps?