Forum Discussion

EllaJ234's avatar
EllaJ234
Frequent Visitor
3 years ago
Solved

Matrix removing duplicates (Dates)

Hi,    I have a set of data which shows the number of bugs a repoter has. The table contains columns for reporters name, the bug ID number and the created date.    I would like to view this on a ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  EllaJ234 ,

    I created some data:

    You might consider using a calculated table:

    Table 2 =
SUMMARIZE('Table',
'Table'[created date],'Table'[Reporterreporters name],
"Count",COUNT('Table'[ID number]))

    Result：

    If you need pbix, please click here.

    Matrix removing duplicates (Dates).pbix

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Use a measure for the bugs

Number of Bugs = SUM(Table[Bugs])

EllaJ234's avatar
EllaJ234
Frequent Visitor
3 years ago

Hi Paul, thank you for your reply! 

I tried this & it's still showing the same output. Do you know if there's maybe a grouping feature i'd need to use to pull all the duplicated dates into one date?

 

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    3 years ago

    Can you provide sample non-confidential data or PBIX file?