How to add Missing rows and add zero % for missing rows

Hi Surendra_thota,

These missing months don't exist, so let's create them. (Modeling -> New Table -> input this formula)

Date =
DISTINCT (
    SELECTCOLUMNS (
        CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2017, 12, 31 ) ),
        "Month1", EOMONTH ( [Date], 0 )
    )
)

Create a relationship from "Month1" to "month";

Then join the two tables together.

Table 2 =
NATURALLEFTOUTERJOIN ( 'Date', 'Table1' )

Best Regards!

Dale