Forum Discussion

dimitrishuk's avatar
dimitrishuk
Icon for Helper I rankHelper I
7 years ago

Daily cumulative average inventory value

Hi,   I'm trying to figure out a way to re-write the following formula. The end result should be an average of the closing balance for the past 365 days.   Here is the closing balance forumla   ...
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi dimitrishuk,

if you include sample data in your posts, it is much easier to help you.

Without knowing your data, it becomes a bit of guesswork. Try this and see if it helps you getting what you want:

Average Daily Balance =
VAR _maxdate =
    CALCULATE ( MAX ( 'Date dimension'[date] ); ALL ( 'Date dimension' ) )
RETURN
    CALCULATE (
        [closing balance];
        FILTER (
            ALL ( 'Date dimension'[date] );
            'Date dimension'[date] <= _maxdate
                && 'Date dimension'[date] > _maxdate - 365
        )
    ) / 365
regards,