Filling missing Year-Month rows on a Table (no script)

[Alessandro_TZ9]

Hello,

I need to fill the rows of a straight table with missed year-months, due of zero values.

For some reasons I cannot modify the script, so I must find a front end solution.

Below an example (good case):

Right case

Below a bad case, to be corrected filling the missing year-month rows with zero:

The 1st column formula:

" =Dual(Year([acq.ba-dboll])&'-'&Month([acq.ba-dboll]),MonthStart([acq.ba-dboll])) "

" [acq.ba-dboll] " is the Date field.

Any ideas? Thanks for helping

Alex

[MatheusC]

@Alessandro_TZ9 

see this Alt() to add to the missing value 0:

Measure:
Alt(YourExpression,0)

- Matheus