Learning resources about disconnected date tables

[Jamie]

Something is telling me I need a disconnected date table; my report focuses on sales at a weekly level, and so when I drop a graph on there, I just get a dot as that’s all the dates that are in current context.

Can anyone point me at a good resource for handling how I go about viewing both all of my data in a graph, or at least up to the selected date, as well as week-specific data? I have full access to the membership portal if that helps. I am going to have this situation an awful lot over the next few months so I want to learn the best way . Thank you.

Jamie

[AntrikshSharma]

@Jamie

Cumulative Transactions

As Greg rightly said you would need a disconnected table for this, the logic behind this is that: behind the scenes SUMMARIZECOLUMNS prepares the matrix and when you have a selection on a slicer then that code will filter query generated by SUMMARIZECOLUMNS, which will result in only those months that are selected in a slicer. Before your DAX code in PBI starts working, SUMMARIZECOLUMNS has completed its task and gives you a matrix visual on which your DAX code has to work/iterate, so in orde…

Obtaining data for different data periods

@JoaoMonteiro As Brian has suggested here disconnected table is the way to go, and here is another way to do it. [image] Measure = VAR CurrentMaxYear = CALCULATE ( MAX ( DisDates[Calendar Year Number] ), ALLSELECTED ( DisDates ) ) VAR PrevYear = CALCULATE ( MAX ( DisDates[Calendar Year Number] ), DisDates[Calendar Year Number] < CurrentMaxYear, REMOVEFILTERS ( DisDates ) ) VAR CurrentMonth = MONTH ( TODAY () ) --Replace with your own criteria of calcula…

Show Last Year’s First 2 Months + This Year’s Current Month | Part 1 | Power BI DAX

[Greg]

Hi @Jamie. Perhaps select the date slicer first, then using EDIT INTERACTIONS from the FORMAT menu would allow you to have one (or a set of) visual(s) remain unaffected by your slicer selections, while the remaining visuals are affected.
Greg

[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

[Jamie]

Thanks all, I will be checking out all those resources over the weekend.

[EnterpriseDNA]

Hi @Jamie, we’ve noticed that no response has been received from you since the 28th of March.

You mentioned that you’ll be checking the resources over the weekend.

We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.