Forum Discussion
kmes912
Helper I
Helper IPrevious Month Works for Certain Rows, But Some are Blank, Total is Correct
When looking at the summary matrix, the values are different than when I show the department matrix showing details. Visual 1 shows correct and totals are correct at -598, but the details of the ...
amitchandak
Super User
Super Userkmes912 , Is '01 Lookup Date' is a date table and also marked as date table in power bi (Right click)
Check 5 reason why TI fails - https://www.youtube.com/watch?v=OBf0rjpp5Hw
kmes912Helper I
Helper Iamitchandak Yes it is marked as a date table. So bizarre that it shows for the other departments but not this one. I verified that 0431 exists on both the fact and dimensions tables. I dont get how it can pull current month fine but when you refer to prior works for certain depts but not for all.