Forum Discussion
Post PatronGet EOMONTH Currency RATE for accumulated balance
Hi Digger
There is nothing wrong with your measures, I think the blank portion of the matrix is due to the fact that you are using date fields in both the rows and columns causing a change in the calculated range of the measures.
I would suggest that you consider removing the date fields from the columns in the matrix visual. Set the slicer style to “Less than or equal to” in the Visual Formatting settings, and view the currency rate for the accumulated balance up to the selected year.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post PatronAnonymous I cant remove date fields from the columns in the matrix visual, also i need add one more field and slicer KODAS_ZS which also does not shown in matrix visual. But i need see ALL info!!
because 0 zeroes show on calculating Sum_EUR, but on Sum_Currency it can be not equal to 0 (because on wrong rate used when countd Sum_Eur), that what i need to find!!
Also Values should be shown for all fields, but here some missing