Forum Discussion

Dlahey's avatar
Dlahey
Icon for Helper I rankHelper I
3 years ago

Comparing 2 Custom Time Periods to Calculate Sales based on # of Sales Dates

Hi Friends,   I have completed following an amazing thread of half year time intelligence: https://amitchandak.medium.com/half-year-time-intelligence-b8ba09b90b9e    I was hoping to get some sup...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Dlahey,

You can try to use the following measure formula to get the rolling previous half year to date results based on current date:

LHYTD =
VAR currDate =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        [Net],
        FILTER (
            ALLSELECTED ( 'Working_Days' ),
            Working_Days[Is blank sales] > 0
                && 'Working_Days'[Date]
                    >= DATE ( YEAR ( currDate ), MONTH ( currDate ) - 6, 1 )
                && 'Working_Days'[Date] <= currDate
        )
    )

Regards,

Xiaoxin Sheng

Dlahey's avatar
Dlahey
Icon for Helper I rankHelper I
3 years ago

thank you so much for your time and expertise. I think this gets me really close to my desired solution.

 

my var currDate = 12/31/2023

is there a way to add to the variable max date = working_days.[date] where blank sales are >0?