Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
what about something like this:
Measure 2 = if( ISBLANK([PMSComplaintsMN]),0,[PMSComplaintsMN])
hi nick
i have zero values for all material_id i the Sales table but not the complaints table...if that helps?
hi nick
the zeros have to be for those data points only 12 months. July 18 to June 19
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |