EasyBI - Specify table for current month ONLY

[John Philander]

image2016-10-25 9:36:41.png

Can someone please assist. I have created EasyBI reports but I only want to show the data from for the current month. How can I filter this to always just show the data for the current month?

Thank You.

image2016-10-25 9:36:41.png ‏109 KB

[Martins Vanags · Accepted solution]

Hi John,

You could create a new calculated member in "Time" dimension using code below and then select it

Aggregate({[Time].[Month].CurrentDateMember})

Here is an attachment

current month - calculated member.gif

Please contact support@eazybi.com if you have further questions regarding this!

Kind regards,

Martins Vanags / support@eazybi.com

current month - calculated member.gif ‏1570 KB

[John Philander]

Thank You so much for your assistance. That was so easy and it worked.