Matrxi missing day data zero

Hi Anonymous 

1. Create a new table

calendar =
ADDCOLUMNS (
    CALENDAR (
        DATE ( CALCULATE ( MIN ( 'your table'[Year] ), ALL ( 'your table' ) ), 1, 1 ),
        DATE ( CALCULATE ( MAX ( 'your table'[Year] ), ALL ( 'your table' ) ), 12, 31 )
    ),
    "calendar_year", YEAR ( [Date] ),
    "calendar_month", MONTH ( [Date] ),
    "calendar_day", DAY ( [Date] )
)

2. Create calculated columns in your table and new table

in calendar table
merge1 = [calendar_year]&"-"&[calendar_month]&"-"&[calendar_day]

in your table
merge2 = [Year]&"-"&[MONTH]&"-"&[Day]

3. create relationships as below

4. create measures in your table

Measure = IF(SUM('your table'[INDIA])=BLANK(),0,SUM('your table'[INDIA]))

Measure 2 = IF(SUM('your table'[UK])=BLANK(),0,SUM('your table'[UK]))

Measure 3 = IF(SUM('your table'[USA])=BLANK(),0,SUM('your table'[USA]))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.