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

[Anonymous]

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.

[Anonymous]

what about something like this:

Measure 2 = if( ISBLANK([PMSComplaintsMN]),0,[PMSComplaintsMN])

[Anonymous]

hi nick

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

[Anonymous]

hi nick

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