Forum Discussion

abhishekrws01's avatar
abhishekrws01
Helper I
2 years ago

How to fill missing dates

Hello - I am looking for some help.    I have the following three tables in the model: 1. Calendar table - has all the dates 2. DailyTxdataSQL - Fact table recording sales by day and country. 3....
Need Help
AmiraBedh's avatar
AmiraBedh
Super User
2 years ago

Try the following : 

Working Day_Table = 
SUMMARIZE(
    ADDCOLUMNS(
        CROSSJOIN(
            'Calendar',
            Region
        ),
        "DailyTxData", RELATED(DailyTxDataSQL[Weekdays])
    ),
    'Calendar'[Date],
    Region[Country],
    Region[Display Country Name],
    "Working Days", IF(ISBLANK(MAX([DailyTxData])), 0, MAX([DailyTxData]))
)
abhishekrws01's avatar
abhishekrws01
Helper I
2 years ago

Hi - Thank you for looking into it. I get the following error.

Thanks