cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
analyst31 Regular Visitor
Regular Visitor

Rolling calculation measure help

Hi,

 

I have a budget to actuals matrix that has a measure for the rolling variance between the budgets and actuals on there. So if the % spent is 10% on month and 15% the next, then that month would say 25%. 

 

My code looks like this, it works on one matrix but not the others. I think it may have to do the the "ALLEXCEPT" line. though i dont know for sure.

 

% Spent EXP = 
IFERROR (
    CALCULATE (
        SUM ( GLEntry[Expense] ),
        FILTER (
            ALLEXCEPT(GLEntry,Glacount[Account]),
            GLEntry[Entry_date] <= MAX ( GLEntry[Entry_date] )
        )
    )
        / CALCULATE ( MAX( GLEntry[Expense Budget] ) ),
    0
)

Here is what the matrix currently looks like as well.

22.JPG

1 REPLY 1
Community Support Team
Community Support Team

Re: Rolling calculation measure help

Hi @analyst31,

 

Could you please share your sample data or pbix to me?  if you don't have confidential data. Please upload your files to One Drive and share the link here.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.