Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

0 if data is missing

Hi everyone,   I have the following problem:   I have 10 Materials, with Data for different dates. If I create a table (with the Materials an the Data for the months) with a filter for each month...
Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    You can also try  to using formula as below to repace your original field "data"

    Measure= sum('Table'[data])+0

    If it doesn't meet your requirement,please share your expected result in excel.

     

    Best Regards,
    Community Support Team _ Eason

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, Anonymous 

You can also try  to using formula as below to repace your original field "data"

Measure= sum('Table'[data])+0

If it doesn't meet your requirement,please share your expected result in excel.

 

Best Regards,
Community Support Team _ Eason