Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mickey
Frequent Visitor

Create new table repeating dates for unique values of another field

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!
3 REPLIES 3
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

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. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




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

mickey_0-1686181582353.png

 

you doble checked there its a column naed like that? 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.