Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Anonymous,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |