Calculed Offset as Axis

DAX DAX Calculations
6

@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
image991×543 38.9 KB

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 with the main data based on Campaign ID.

I hope this is helpful. Full solution file attached below.

1 Like