Forum Discussion
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...
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.
Which version is correct: PowerBi or SQL?
The SQL database holds the correct data. But for some reason, PowerBI isn't returning all the information.