Remove duplicate rows in Eazy BI report

[Madhavi Pasapula]

Hi, 

I have a report that looks as below in Eazy BI and I want to remove the duplicate rows. Can anybody help please?

[Marita Burgio · Accepted solution]

Hi @Madhavi Pasapula

Thanks for posting your question!

I suggest switching to "Name" level member in the Fix Version dimension. It will group results by Fix Version name.

You can then create a new calculated measure using the following code:

TimestampToDate(Max(
  Filter(
    ChildrenSet(
      [Fix Version].CurrentHierarchyMember
    ),
    NOT IsEmpty([Fix Version].CurrentHierarchyMember.Get('Release date'))
),
  DateToTimestamp([Fix Version].CurrentHierarchyMember.Get('Release date'))
))

This formula will return the latest release date among the child versions of the current Fix Version member. Here's an example of my demo data report, showing only one line per Fix version and the release date:

I hope this helps!

Best,
Marita from support@eazybi.com

[Madhavi Pasapula]

Thank you very much Marita, it worked. I just linked it to Time Dimension and got the report needed. Thank you so much.

Thanks

Madhavi