Learning resources about disconnected date tables

[BrianJ]

@Jamie,

Jamie,

In addition to the resources that @AntrikshSharma posted above, you may find this thread relevant and helpful as well:

Calculed Offset as Axis

@Wlknsn, Okay, I was able to OCR your screenshot to get the data in. Here are the results with the calculated column calculated via: Campaign Date Offset = DATEDIFF( Data[Campaign Start Date], Data[Date], DAY ) [image] I would characterize this solution as “quasi–dynamic”. I created a disconnected table to hold the Campaign IDs and the Campaign Start Dates. You can update the campaign start dates in this table in Power Query and when you close and apply, it merges these dates w…

• Brian