Forum Discussion
Complete date series
Hi a Newcomer to DAX and PBI here, i want to "complete" a date series in my dataset. The following scenario: I feed a data cube from the server into my PBI desktop application. However, this ...
tamerj1
Community Champion
Community ChampionHi Anonymous
what could be the purpose of having this blank row?
Hi tamerj1 ,
the individual values are cumulated in a rolling sum for each group over the days each month. After that the series are supposed to be visualized in a simple graph (for now).
The visualization of a single group (like just "ABC") works fine, but when you pick multiple group the cumulative values are supposed to be added together and displayed.
This works fine as long as the two groups have the same days within each month.
The summation is dynamic enough to take the last cumulative value if there is a blank.
But if there is an entry missing one element gets skipped which results in this drops in the graph (s. below):