Forum Discussion
Date Hierarchy Displaying too much data
If I think I know how to answer this, I'm using my own table with dates in it. I'm using the built-in hierarchy capability on the axis.
% column in your report seems to be a calculated measure and wondering if that is what makig it show data in the future?
Two things:
1. Can you remove % column and check if it doesn't shows blank rows?
2. if you remove % column and you are NOT seeing blank rows, share the measure you used for %
Removing that column is showing the matrix correctly now. What if I aggregated my data by a month level rather than at a date level?
As mentined if you share your % calculation, it will help to understand what is going on and find out the solution. Thanks!
Sorry forgot the calculation.
% Change from Budget = IF(
(SUM(em_encounter_fact_date_agg[Pt Volume])/ sum(em_encounter_fact_date_agg[adj_arrivals_budget]) - 1) = -1 && ([Pt Volume Change %] = 0) && [Staff Hours % Change] = 0, 0, SUM(em_encounter_fact_date_agg[Pt Volume])/ sum(em_encounter_fact_date_agg[adj_arrivals_budget]) - 1
)
I have the IF because without it, the future months were showing as -100.00% and causing havoc with the Percentage Total.
Hi,
Try this
=IF(ISBLANK(SUM(em_encounter_fact_date_agg[Pt Volume])),BLANK(),your_formula_here)
