Create new table repeating dates for unique values of another field

[mickey]

Hi,

I created a table with the formula:

New Table =

    SUMMARIZECOLUMNS(

        'Date Table'[Date],

        Ward[Unique ID]

    )

This worked as intended as I need to create a new table with the dates repeated for each Ward Unique ID.

The problem I ran into was when trying to connect this table with the existing Date Table it turned up a circular dependencies in the relationship.

My thought are if I use a different calc for the date portion of my New Table such as CALENDAR(MIN('Date Table'[Date]), MAX('Date Table'[Date])) that should remove the circular dependency, I just don't know how to add back in the column which repeats the date range for each Ward Unique ID.

Thanks!

[StefanoGrimaldi]

you try with this approeach to see if it works for you: 

new table = ADDCOLUMNS( CALENDAR(MIN('Date Table'[Date]), MAX('Date Table'[Date])), "Ward Unique ID", Ward[Unique ID] )

basically you creating to table by separate and them merging them in this dax I think it should do the trick if I understand correctly. 

let me know to see further adjustments. 

[mickey]

HI @StefanoGrimaldi 

When I try that formula I am unable to add in the Ward[Unique ID] as no table dimensions or fields appear, only measures

[StefanoGrimaldi]

you doble checked there its a column naed like that?