Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Missing Data Rows

Hi All,   I am trying to create a table in PowerBI that shows the total records that are in each status split by the group they are in. I originally take the data from an SQL Database. Then I forma...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi all,

    Thank you so much for your help, and showing me the matrix and that date slider 🙂 

     

    I figured out what my issue was. It was in the SQL.

    SELECT ID, Status, Group, MIN(Date)
    FROM Table
    WHERE Date
    BETWEEN '2020-10-30' AND '2020-11-05'
    AND Group= 'A'
    AND Status = 'Staus1'
    Group By Group,Status, ID
    ORDER BY MIN(Date) DESC

    It's because I used the between clause to compare the data. Obviously, If I ignore everything before that date the minimum date changes. So that number will be higher than the numbers in the report. 

HotChilli's avatar
HotChilli
Community Champion
5 years ago

This is confusing.  What data is missing?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It was just me being an idiot. PowerBI was working as intended but I used the minimum date when I grouped the data to compare it. But when I used the between clause in the query the results are different due it the database ignoring previous events.