Forum Discussion
Matrix not summing my values
I have this formula and the matrix is not summing in the totals.
Average Holding Period = IF(FIRSTNONBLANK(Capex[Fully E. N. Leases & A. Year],TRUE()) = YEAR(TODAY()), MONTH(TODAY()), IF(LASTNONBLANK(Capex[Fully E. N. Leases & A. Year], TRUE()) = LASTNONBLANK(Capex[Built Date],TRUE()) , 12 - (month(average(Capex[OTHVR Actual Date]))) , 12 ))
They are divided in years, but for some reason it displays 12 in the grand total.
7 Replies
- jtownsend21
Responsive Resident
Can you share some sample data and what visualization you are using?
- jtownsend21
Without sample data I am not sure how to help.
Please see this post:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
