Forum Discussion

rxt's avatar
rxt
Helper I
4 years ago
Solved

DAX Add Column from other Table

I have a calendar table example below. Date Year start of Year End of year 1/1/2021 12:00 AM 2021 1/1/2021 12:00 AM 12/31/2021 12:00 AM 1/2/2021 12:00 AM 2021 1...
  • colacan's avatar
    colacan
    4 years ago

    Hi RXT,

     

    After creating a calendar table;

    Date = CALENDARAUTO()

     

    Please try below

    ResultTable =

        Filter(
            CROSSJOIN( VALUES( Date[Date]), DataTable ),
            [Date] >= [Start_Date]  &&
            [Date] <= [End_Date]
        ) 

     

    Hope this helps you. Thanks

colacan's avatar
colacan
Resolver II
4 years ago

Hi RXT,

 

After creating a calendar table;

Date = CALENDARAUTO()

 

Please try below

ResultTable =

    Filter(
        CROSSJOIN( VALUES( Date[Date]), DataTable ),
        [Date] >= [Start_Date]  &&
        [Date] <= [End_Date]
    ) 

 

Hope this helps you. Thanks

rxt's avatar
rxt
Helper I
4 years ago

Hi Colacan, the CROSSJOIN FILTER did the trick. Many thanks!!! you are fantastic👍