So I have a dataset with budget per GL account, the problem is that the datasets contains 24 periods, 12 periods (1 to 12) with either 0 or a random number and 12 consistent periods (1 to 12) with the correct budget. Reference 1. in the screenshot below/
When merging dimensions and creating a detail that returns the budget, it obviously returns the #Multivalue error.
I tried to fix this by adding a =First measure, which lead to reference 2. in the ss below. I
I then created a dimension that equals the measure, but this returned no data in a different query.
What’s the best way to fix this, is there a way to delete just the 12 periods with inconsistent budgets?