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)                     ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

what about something like this:

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

    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
    7 years ago

    hi nick

     

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