Time Comparison - Half 2 vs. Half 1 based on time elapsed in H2 vs. same time period in prior half

[Dlahey]

Hi,

How can I compare half 2 sales results (Jul-Dec) as of Aug 26th vs half 1 results (Jan-Jun) same time period?

ie. H2 as of Aug 26th = 40 working days vs. H1 first 40 days from Jan01?

Currently I have a sales sum for H2 using datesbetween and a sum of sales for H1 using dates between and then I calculate a % to sales target for the full half. I am trying to provide a secondary calculation which compares H2 (first 40 days) vs. sametime period H1 (first 40 days).

Thanks so much in advance,

[Dlahey]

just following up on this one here - thanks a ton

[amitchandak · Accepted solution]

@Dlahey , refer to my blog on half-year intelligence

https://amitchandak.medium.com/half-year-time-intelligence-b8ba09b90b9e

[Dlahey]

@amitchandak thanks so much, I've uploaded a date table into powerbi which ends at the end of 12/31/2022... is there a way for me to factor into the "Last Half Year Till Date" the fact that dates 08/19/2022 to 12/31/2022 is not being added?