Forum Discussion

hholtshopple's avatar
hholtshopple
Frequent Visitor
7 years ago
Solved

Join to Date table and Replicate

Hello,   I have received a data set that is grouped by date, each row has a start date and an end date among other key identifiers. I want to ungroup by date these in order to give a count on each ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Hunter,

     

    Please download the demo from the attachment.

    Table =
SELECTCOLUMNS (
    FILTER (
        CROSSJOIN ( 'Calendar', 'Table1' ),
        'Calendar'[Date] >= Table1[Start Date]
            && 'Calendar'[Date] <= Table1[End Date]
    ),
    "Date", [Date],
    "Car", [Car],
    "State", [State]
)

    Join-to-Date-table-and-Replicate

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Hunter,

 

Please download the demo from the attachment.

Table =
SELECTCOLUMNS (
    FILTER (
        CROSSJOIN ( 'Calendar', 'Table1' ),
        'Calendar'[Date] >= Table1[Start Date]
            && 'Calendar'[Date] <= Table1[End Date]
    ),
    "Date", [Date],
    "Car", [Car],
    "State", [State]
)

Join-to-Date-table-and-Replicate

 

Best Regards,

hholtshopple's avatar
hholtshopple
Frequent Visitor
7 years ago

Thank you! Will implement this method on my data table. 

 

-Hunter