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.