Forum Discussion
Assign Missing Dates With Zero for Value
Hi, I have a list of [Projects] each project has a [Date] and a [Value]. The dates are by month, eg. 2014-12-01 Some of the projects don't have any data for some months. I need them all to show al...
v-diye-msft
Community Support
Community SupportHi Anonymous
Why don't try to replace the null with 0 in query editor?
There are no nulls. If a record was not created for the project on that day, then nothing got recorded. This is in Dynamics btw.