EASYBI Filter One Specific Measure By Time Not Entire Report

Questions & Answers
1

Looking to build a report that shows: Current Issues Created and Issues Created Last Week. I would prefer not to use the Time dimension as I don’t want to split the first column (Current Issues Remaining). Is there a way to specifically code into a report calculated measure to

[Measures].[issues created] - ([Measures].[Issues Created], [Time.Weekly].CurrentMember.PrevMember,

but its getting errors. Any advice?

2

UPDATE: Took a few days, but sometimes the code is so simple it’s right in your eyes!

([Measures].[Issues Created], [Time.Weekly].[PreviousWeek])

1 Like
3

@rodjay5
Try this formula

([Measures].[Issues created],
[Time.Weekly].[Week].CurrentDateMember.PrevMember)

Martins / eazyBI